>>Create a view from these two tables and use it as a RecordSource.
>
>I tried this option, the problem is I am appending new records to the team id / Player id table. When I created a view with the Id's and the players name and appended a record it attempted to append a new record to the player table in addition to the team id / player id table.

u should be able to set the view (using DBSETPROP) so that the updates on the key for the player table will not be sent to the "parent" table
and thus no record will be added (u can see VFUG tips and VFP manual on using DBSETPROP/DBGETPROP)

Arnon