I've done the bulk of the work for a final database assignment and the last part of it is driving me to despair. I figured I'd ask you good folks for your input. For the record, my name is Greg H. in case any other students in the program (there are roughly 200) find this post and try to steal the bulk of my work.
Basically I have two individual yet related problems. (I've attached the database to make it easier to follow).
My database is a database of a Sports Association (Lame Events); it contains information on participants, events, clubs, participant-events (participant performance), locations and sponsors. I have all the reports and queries done and I've populated it with dummy data. What remains is: I have to create numerous forms that allow the user to make updates to information that is related to other tables.
I'll post the list here to give you an idea:
Create and Save Forms on the new Database to do the following:
a. Allow for the input/update of Events.
b. Allow for the input/update of Sponsors.
c. Allow for the input/update of Clubs.
d. Allow for Sponsors to be tied to an Event.
e. Allow for the input/update of Locations.
f. Allow for Locations to be tied to an Event.
g. Allow for the input/update of Participants.
h. Allow for Participants to be tied to another Athlete (i.e. the person who referred
them).
i. Allow for Participants to register for an Event.
j. Allow for Participants to be tied to a Club.
k. Allow for results to be recorded for a Participant in an Event.
The first three are simple. It's just a single table form. The others though, I'm not sure how to approach it. In theory I know, for example, for an event location to be updated. I need to be updating the foreign key "LocationID" in the events table, but it's not very user friendly to have to type in a number. If anyone needs clarification or wants to talk about what it is I'm trying to accomplish more specifically, please let me know.