Hi, i have data in a linked table, however its not working as i need.

example, 2 tables.  one is a subtable containing teams available for which days (monday  or friday)  (there is more to the table than this, but that is all that matters in this example.

so team CROMWELLS may play on both monday and friday.  so there will be 2 rows in this subtable.

the 2nd table captures the results for the games.

so there are 2 columns that link to the sub table.

however, when they are being populated, due to the fact that their are 2 rows in the sub table, teams appear twice.  limiting this to 1 isnt the issue.

solution 1...

so, instead of just showing team in the drop down...

Table: LINK-Season-Day-Divison-Teams (id: 40), Show column: Team, Value from column: wdt_ID

could it show division and team?

Table: LINK-Season-Day-Divison-Teams (id: 40), Show column: Division, Team, Value from column: wdt_ID

solution 2... (better)

rather than show all of the subtable entries TEAMS, only provide those TEAMS that match the "day" column in the table 2 (that its being stored in)

see screenshots for visual representation.