To make this simple: I have no experience using FMP or any other database software.
My problem is that I have set up a database with two tables. These are for contacts and work orders. The contacts include the company name, contact, and billing information. How would I go about making it so that when someone chooses the company name from the drop-down menu on the work order form, the billing information automatically fills in? I have gone to the relationships tab and related the fields, but it won't bring up any info from the company aside from the name when I select it.