Thank you for responding. This bit:
When defining both value lists, use the 'Use values from field:' option. For the first value list, 'Use values from first field [New Table:Sport]', 'Include all values'.
For the second value list, 'Use values from first field [New Table: Organization]', 'Include only related values starting from: [First Table]'
Make sure your relationship between [First Table] and [New Table] is by the Sport fields.
Is a bit over my head, I will play around and see how it goes. As for the second part, I figured it was an auto-enter serial field but it lives in the actual value list field name. Do you know how you can set one up in there? It basically acts as a counter for all the names you store in a field. In the database, I am trying to emulate, it does it for both value list fields and edit box fields. Have any suggestions on how to set that up?
Again, thank you.
'Playing around' usually results in a solution, 9 times out of 10 - if you have the knowledge. Rest of the time requires advice, and/or more knowledge.
I'm not quite sure I understand the second part - specifically 'it lives in the actual value list field name'. The unique ID is in the name of the field using a value list? Or, the value list has a list of names, plus the number of times those names were chosen? That part is fairly easy, but it involves a self-relationship and a calculation field.