Hi all, I'm new here and am hoping you can help me with a problem i have with my database (attached).
Basically, The database is used to store Swimmers' details and their times for varying events (an event is just a race, e.g., 50meters Backstroke, so, one swimmer would have a time for an event and One swimmer can have many times, and one Event can have many times).
There are 3 tables currently being used (there are 5 in the database but only 3 are used at the moment)
tblEvents currently stores every possible event.
tblSwimmers stores every swimmer and their details.
tblTimes stores swimmers times for different events.
Now, i've tried to name my tables and combo boxes etc as well as possible but some are still a bit vague. Sorry.
Now for the problem, frmAddSwimmerMAIN (and frmAddSwimmerSUB and frmModSwimmerSUB) doesnt seem to be working properly and i'm really sorry to pose such an open ended problem but i have no idea why.
Using the form and the three tabbed pages i'm supposed to be able to add, delete and search for and modify swimmers personal data and race times. Now i can get the personal info working but the times are a bit iffy, I seem to be able to input race times ok but when i search for them i get nothing.
Thats about all i can say because i'm a big Access Newbie.
Just one more thing; events with an Odd IDEvent are female events and Even IDEvents are male events. Thus, if a male swimmer has an odd IDEvent and vice versa then somethings gone wrong. I think my current test data is wrong but i cant fix it.
So, please can i have someone have a look at the database and sort of say where i'm going wrong. I dont expect anyone to put loads of work in and get it up and running or anything (unless you really want to, then feel free) but if you could say where i'm going wrong then it would be a big help.
Thanks a million.
Mike