I have 2 tables: customer and appointment. I can search the customer view to find the customer record I want.
I have a Lookup in Appointment to Customer, so that when you create a new appointment, you choose the customer. But, how do I then click on something to see *all* past appointment records for this customer?
I can imagine a button in each row of the Customer table where I could click "See Appointments" and it would bring up the Appointments page, but of course, only showing the records for that customer.
This seems like a really simple thing, but I can't quite figure out how to do it with this tool.
Any help is appreciated. Thanks.
Vic