Newbie question: Value list to pull data from another table

[Marco L.]

Hello,

I have 2 tables "Customers" + "Appointments".

The Customers table collects all the basic info: Name, Address, Phone number, etc.

In Appointments I've created a drop-down list (a value-list based on customer names in the Customer's table). That works fine. However how would I get it to pull the related "Address" + "Phone number" into the Appointments view once I select their name from the drop-down? I've created duplicate field names in both tables, and linked those fields via a relationship.

I'm just at a loss as to what would be the type of Auto-entry options to get this working.

Any guidance would be appreciated, thanks.

Marco

[Marco L.]

Hi... I did manage to figure it out... It was just a matter of creating the proper relationship between the necessary fields in both tables.