It's Been Forever, I Need Help Displaying Multiple Tables on a Form
I've used Access to create a couple databases, nothing terribly complex, and would like to do the same with File Maker. At the moment I'm working on a database for my company. I'm working on displaying a contact management form. I have one table for contacts with the contact ID, and then fields like first, last, etc. And then I have another table for phones (since someone can have more than one phone) with phone_id, contact_id, phone type and phone #. I have a relationship created between the contact ids in both tables. So then on my contact form, how do I get it to display a field for the phone, so that I can input the phone types and phone numbers.
Seriously this is like the most basic thing ever, and I can't believe I've forgotten how to do this. Could someone walk me through in baby-steps, cause obviously I've forgotten something major, and I don't know what that is. Thanks.