AnsweredAssumed Answered

Need help setting up auto-fill lookup

Question asked by hoyeboye on Dec 1, 2008
Latest reply on Dec 1, 2008 by davidhead

Title

Need help setting up auto-fill lookup

Post

I have a customer database that I am setting up. At the bottom of the customer page, I would like a table that lists information from appointments with the particular customer. The formula in my head goes like this:

If Customer:Fullname=Appointment:Fullname,

Then

Copy Appointment:Date to Customer:Date(On disp at bottom of Customer page)

Copy Appointment:TimeIn to Customer:TimeIn(On disp at bottom of Customer page)

Etc.

 

I am new to databases, so please try to use simple terms. Thanks.

 

Here are screenshots of the tables

Customer Table

Customer Table

Appointments Table

Appointments Table 

Outcomes