"I have one table, in it I have contacts and I have jobs..."
Therein lies the trouble. You should have two tables for this, one for contacts and one for jobs. Then you link your tables by a ContactID number. Your portal would then list records from Jobs on a table that references contacts.
Thanks so much for the response.
I reorganized based on your suggestion and indeed it works a bit better but my problem persists. The portal allows selection just fine and entries are displayed okay but what happens is that for every job I assign to a contact in the contacts table a new job entry is entered into jobs table. This makes sense I guess because I said "allow creation of new records based on this relationship" but this isn't what I want to happen.
I want to have a multiple contacts and a SINLGE job and assign that single job to several people. For the people I want to see all the jobs that they've worked on, at the job I want to see all the people that worked on that job.
I just can't pinpoint what I have set up incorrectly.
Thanks so much.
Let's reverse things on the layout then. Base your layout on Jobs and make the portal refer to Contacts. Enable the "Allow creation.." option for contacts instead of Jobs.
Which layout should I run this test on? The Job overview has a different layout then the Contacts overview and both have 2 different portals on them.
On the Jobs layout I display the name of the contact, on the contact page I display the job id.
Any layout that refers to your Jobs table. You can create a new blank record and test it there or add it to an existing layout. (enter layout mode and choose layout setup... to see what table is listed there as the "reference" table.