AnsweredAssumed Answered

Table Relations

Question asked by PageWatkins on Dec 2, 2011
Latest reply on Dec 2, 2011 by PageWatkins


Table Relations


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.