In Filemaker Pro v5

I want to have a dynamic value list in one layout based on the data

entered in multiple fields in a different layout.

Example:

One FMPro database file.

Each record in the database contains info on a different football team.

In one layout there is a separate field for each player's last name.

In another layout I want a pop-up menu listing all the last names of the

players.

It is simular to the "get value from field" option but instead of

creating a value list of all entries in one field from all records in a

file, I need a list with the entries in multiple fields in one record.

Is this possible?

Thanks,

------------------

Bryan Porter

MacIntact

Hi,

I was trying to do something earlier before but like you couldn't get it to work.

The solution I finally went with was to create a seperate database which has two fields, which in your case would be team and player name. Then link this to your other database on the team name. This way you can generate a value list based on team in the main database. Also to get all the names of players of a particular team to display on the layout, create a portal based on the team relationship.

I hope this makes sense, let me know if you need clarification.

Louisa

Yes, I would recommend the use of 2 files as it simplifies keeping your records current when/if players change teams. But......sure, if you truly want to create a dynamic list comprised of the contents of designated fields in one record you can do it.

1. You need a field that will always have a unique value for each record (SerialNbr)

2. Define a self relationship (SelfUnique)

SerialNbr=::SerialNbr

3. Define a calculated field (Concat) to get a text result from surname field contents (separated by "returns") - Surname1 & "