You'll need a relationship between invoices and contacts that looks like this:
Invoices::CompanyID = ContactsByCompany::CompanyID
ContactsByCompany is a new table occurrence of Contacts you create by clicking on Contacts, then clicking the button with two green plus signs in the bottom corner of Manage | Database | Relationships.
With that relationship defined, you can set up a value list that lists ContactID and Contact Name from ContactsByCompany, use only related values starting from Invoices.
PhilModJunk, Thank you very much, this worked perfectly!
I have been racking my brain for a few days trying to figure out how to setup the relationship and the related table dropdown for this to work. I learned a lot about relationships while trying to figure it out (but obviously I didnt learn enough =P ). Is there anything that you would recommend reading that explains a very indepth detail about relationships and the filemaker database structure.
Once again, thank you very much and have a great day!
I learned databases in college while getting a degree in computer science quite a few years ago. I then taught myself FileMaker when the current version was 2.1 and have been using it ever since. The FileMaker Training Series: Master the essentials of FileMaker 11 seems pretty decent, but I haven't read or examined any other publications that are available to compare it too.
Others have recommended the "Missing manual" text, but I haven't seen a copy to be able to recommend for or against it.