Simplest approach is to include the drop down menu field as a match field in the portal's relationship.
On the table i'm showing, this wold be a self join ? does it matter which field ?
I want to show records from the same table the portals on
I can't quite guess what your original design for this layout is.
On what table is your layout based? On what table is the portal based?
If both layout and portal reference records from the same table, this would be a self join and require two linked Tutorial: What are Table Occurrences? for the same data source table.
It would be a self join...just not sure what fields to use based on what i had above
Let's say you have this self join relationship:
Lifting_records::SelectPlayer = PlayerLiftRecords::Player
PlayerLiftRecords would be a second occurrence of Lifting_records
Format SelectPlayer as a drop down list of player values and when you select a player from the drop down, you see all records with that value in Player.
Note: Names are not unique. You may want to use ID numbers in the relationship and a two part value list that specifies the player ID for field 1 and the player name in field 2.
Opps forgort I do Have PLAYER_ID
So The Table ? Layout is called LIFT RECORDS
I have PLAYER_ID, NAME, Lift, Classification,Weight for fields
I would choose the layout lift table , copy and rename in relationships and join those two fields
I Have so much to learn about this relationship stuff and table OC....need to read more of your stuff
Hey here is link to file
I am reading all i can but really need to see things....
I keep getting the same lift name showing up
Not sure why
You need to add another occurrence of Lift Form and link it directly to the portal's table occurrence, then use the lift name from this added occurrence to show the different lift names.
FWIW, I'd use two tables here. Create a players table with one record for each table and link it to a lifts records table with one record for each "lift" recorded for that player. Base your layouts on the players table and the portal on the lift records table.
Thanks Phil, really kicking my butt learning this...
I thak you for the help on the value list, i got that down now
But this i'm still having trouble , I attached a file link .
In it on the lay outs a wrote what i was looking for in the self join, and showing portal records both on the lifting table records and the
thank you for all your help