Hello, I am developing an app for a photography competition.
I have two tables:
Photographer (TblPhotographerKey (primary), name, phone, etc.)
Results (TblResultsKey (primary), TblPhotographerKey as foreign key, score for each category.)
The Photographers table and Results table have a 1-to-many relationship based on the photographerkey.
I have a subform for recording the results. A photographer's results are recorded on a single row of the subform. A bound dropdown has the photographer's name and key. The photographer's name is displayed in the control.
When I select a photographer from the dropdown list on the subform it displays correctly but a duplicate record is added to the Photographer table with the photographer's name.
In the Results table the photographerkey (foreign) has the key that was added in the Photographer table.
Any help would be greatly appreciated.
Thanks.
Bill
I have two tables:
Photographer (TblPhotographerKey (primary), name, phone, etc.)
Results (TblResultsKey (primary), TblPhotographerKey as foreign key, score for each category.)
The Photographers table and Results table have a 1-to-many relationship based on the photographerkey.
I have a subform for recording the results. A photographer's results are recorded on a single row of the subform. A bound dropdown has the photographer's name and key. The photographer's name is displayed in the control.
When I select a photographer from the dropdown list on the subform it displays correctly but a duplicate record is added to the Photographer table with the photographer's name.
In the Results table the photographerkey (foreign) has the key that was added in the Photographer table.
Any help would be greatly appreciated.
Thanks.
Bill