I have searched on this and cannot find a thread that seems to match want I need to do.
As part of a database I have 2 tables. One which has players added to it and the other (foursomes table) is filled with data from the players table when user collects data using a form. The user selects three players from the players table and combines them into one record in the foursomes table. I need to compare the two tables to see if the player listed in the players table is now showing up within the records on the foursomes table. The players only that have the two check boxes - Block Entry and Day 3 Only - as true are eligible to be in the foursomes table.
I have attached the two tables to this thread hoping the above makes sense.:banghead:
As part of a database I have 2 tables. One which has players added to it and the other (foursomes table) is filled with data from the players table when user collects data using a form. The user selects three players from the players table and combines them into one record in the foursomes table. I need to compare the two tables to see if the player listed in the players table is now showing up within the records on the foursomes table. The players only that have the two check boxes - Block Entry and Day 3 Only - as true are eligible to be in the foursomes table.
I have attached the two tables to this thread hoping the above makes sense.:banghead: