A portal to create many to many relationships - please help!

[keelbolt]

I am building a database to record teams of people making visits to different places. In order to learn how to do this, I have a simplified database to start with that has only two tables on it for now.

I have - tblPerson containing records of individuals, and tblVisit containing records of visits to geographical areas.

A person may make many visits to different places, and a place may have visits from many different people. Thus a many to many relationship.

I have created a join table, tblPersonVisit, but I am now stuck.

What I want to do is to create a portal on the Visit layout where I can create relationships between the many people making that one visit, and a portal on the Person layout where I can create relationships between the places he visits and that person, so that the visits layout can show the associated people on that visit, and the people layout can show the associated visits for that person.

I can do one to many portals, where I can create records in the 'many' table via a portal on the 'one' table, but I am stuck on how to link existing records in the 'many' to the 'one' via a portal in a many to many relationship.

I have attached a simplified version of my dbase and if anyone can show me how to do this, I would be most grateful. I am at the 'beginner' stage, working my way through FileMaker Pro 10 'The Missing Manual'.

KB

Rooted_v1.8_Simplified.zip

[efen]

like this

Rooted_v1.8_Simplified1.zip

[keelbolt]

Yipes! Thanks. That works brilliantly to add the person, and I will spend a little time working out how - its all in your script, but I haven't done variables yet. I understand variables in PHP, so have some point at which I can start.

What about the other direction - removing the relationship? I suppose it's a case of reversing the script somehow?

KB

[comment]

See if this helps:

http://fmforums.com/forum/showpost.php?post/233897/