Value list not displaying non-unique entries

[mahonia]

I have people and organizations, and I need to be able to pull up a person and find out what orgs they're with and pull up the orgs to find out what people are members.

Here's the problem:

I want to be able to directly add organizational affiliations to individuals, by name, from organizations previously listed in the DB -- via a value list containing organizations.

Also vicea versa, adding directories of individual members to records of organizations -- via a value list containing all records of organizations.

I can get this working, but the value list won't show each name as a unique records. So if I have 2 "kevin Sloans" in the people DB, they are treated as one in the portal.

I don't want to use serialized code numbers (at least not alone) because this would be too hard for users to figure out from hundreds of numbers.

suggestions?

[RalphL]

You double posted this. Please don't do it again.

You have FMP8 so you could use one the new features that allows you to display the second field only. This way the names would show but the serial number would be inserted into the field.

I am attaching a sample file for many to many relationship which uses this feature. It also uses a portal for displaying the availble choices.

ManyToMany.fp7.zip