Request #1 - yes you can set the field to autocomplete using past values or values from a "value list". You could define a value list of players from the name field of your players table.
request#2 - to be able to enter the data for 2 different players on the layout showing 1 match, you could use 2 portals to the player data. Set both portals to use the same relationship and have the one on the left show the first row and the one on the right show the second row. Or you could define 2 relationships between the match and player tables (you can make another table occurance of players by clickng the ++ button in the manage database/relationships window). Then having the fields for player 1 from the first relationship and player 2 from the second.
Thanks Mark for your answer. I have moved forward in my design. The linked score tables have theur records created automatically now
I am now getting stuck on 1 issues:
If I manually encode values for the individual scores, thats fine BUT how do I automatically have FM encode specific values into the aforementionned created records.
1) in the above form, I encode the match number in the match form and would like this number to appear in both of the created individual round records
2) In the above form, the points allocated to each player are calculated by comparing the individual scores of each player (therefore comparing 2 records in "individual rounds"). I would like the result of these calculations to be recorded for each player in their individual round (for later statistical analysis)
Thanks for your insight on this. I am at a loss
OK, found the script triggers in the format menu & got lots of work done setting up values in other fields/other tables upon validation of a field
Also found the tab browsing settings in the menus (RTFN they say, but TNS is my answer ;-) )
Just one peculiar "bug"(?) :
I fill out a matches form (updated look below) and enter the last name; the first name never appear although it is definitely present in the scores table (joined a table view)...
Weird? or not? I've had the first name field point to the scores table and also to the principal players table but to no avail.
We need to look at the relationship from the principal players table and the table that the relationship is based on to see why it is not pulling the first name.
From the graph in your other post it looks like you need to have the Juoeur tables related to the individual rounds table by id player.
Then in layout mode make sure that the Prenom1 field is Juoeurs::first name and Prenom2 is Juoeurs 2::First name