I have created simple relationships before but I am stumped on this one. For example, I have a database of contacts (around 1000 records), and a database of job descriptions (around 100 records). I would like to be able to have the contacts have a portal to where a pop up list would show Job Descriptions and you can select one and/or multiple job descriptions. When this happens, I would like a portal on the Job Descriptions automatically show all the different contacts that have that job description.

I tried creating a direct relationship between the two using an Individual ID and a Job Description ID, however that did not allow for multiple entries to take place.

Thank you for any help that you can provide.

Per request I attached a modified version of my data base with only the data tables and layouts involved in this question. I was not able to return it to how I had it some what working before.

Test.fp7.zip

Edited January 22, 200817 yr by Guest
Added file

It would be faster to find what you did wrong if you attached a no record clone of the files.

Lee