Newbies macintact Posted May 31, 2000 Newbies Share Posted May 31, 2000 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 Link to comment Share on other sites More sharing options...
Louisa Posted May 31, 2000 Share Posted May 31, 2000 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 Link to comment Share on other sites More sharing options...
Bill Hartford Posted June 6, 2000 Share Posted June 6, 2000 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 & " Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8730 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now