Need help setting up auto-fill lookup
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:
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)
I am new to databases, so please try to use simple terms. Thanks.
Here are screenshots of the tables