Multiple record Look Ups??

[effectsguy]

Hello, can someone help? This is driving me crazy!

I have a multi file database that has some relations. One file is a "contact" file with all the people, addresses, etc that has around 100 records. The other file, "Groups" needs to show 2 of the contacts in one record but each in a different tab.

Example: Group 1 has moderators x & y, Group 2 could be moderators a & b, etc. If you click on Moderator 1's tab inside the group layout, it pulls up their contact info (looked up from contacts database)

It works okay for one name, but the problem is that when I go to put in the other persons name, it only shows the looked up data from the first person's contact.

I've tried portals, multiple file references, ect, with the same result.

Any suggestions??

Thanks all, great forum. Sorry if this has been posted before, there's a ton here.

[John Mark Osborne]

Sounds like you are going to need two relationships. The two relationships will be nearly identical except that the Groups file/table file contain a foreign key for each of these relationships. This will allow you to populate the two foreign keys with different contact primary keys so you have two contacts showing on two different tabs.