You need at least two tables but at least three table occurrences for two different relationships.
Staff::__pkStaffID = Phones|assigned::_fkStaffID
Staff::anyField X Phones|all::anyfield
You can then set up a layout based on staff with a portal to Phones|all. Use a portal filter to limit the phones listed to those not assigned to a staff member.
Thank you for your very quick answer and all help! ;-)
Sorry for my late answer.
I can´t get this to work.
When I make a new staff record so comes all phones up again in portal, again and again for every new records. I want to chose one staff and connect this staff to one or more IMEI-number via portal.
What did I doing wrong?
I send my testfile to this thread.
Philmodjunk test.fmp12.zip 70.1 K
I'm replying via phone so can't look at your file just yet, but do you realize that you need two portals?
one lists all available phones and is used to select a phone while the other lists all phones selected for the current staff member.
Now we talking..... ;-)
I just want to say 1000 x THANK YOU for all help!
It is much easier to understand how it works if I see it on your superb instruction video and test it on your file.
So now I can go on and implement your solution in my database.