You need a join table with both the Trip ID and Contact ID in it. -- Steve
Steve B. Gerow FileMaker 8/7 Certified Developer President Abrazos Data Consulting, Inc. Dependable Database Development Pasadena California www.abrazosdata.com FileMaker Solutions Alliance Member Associate Level > From: stephanie shield <[EMAIL PROTECTED]> > Reply-To: FileMaker Pro Discussions <[email protected]> > Date: Mon, 29 Jan 2007 14:59:55 +0000 > To: [email protected] > Subject: related contact names > > Hello, > > I am using Filemaker for a travel company and I want the contacts to connect > in the tables, only for that trip. > > For example, I have a trip in March and I have a list on contacts on that > trip. > > Then I have a table with the hotel information. How do I have the contact > names for only the March trip and not all my contacts? > > Thanks for any help, > Stephanie > > _________________________________________________________________ > Get in the mood for Valentine's Day. View photos, recipes and more on your > Live.com page. > http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701 >
