[b][red]This message was edited by grilledtomatoe at 2005-1-8 10:29:4[/red][/b][hr]
I have been driving myself mad with this one; I have three tables, MEMBER, ATTENDANCE and EVENT. In the MEMBER table I have; Member No. , Name and a load of address stuff which isnt necesary here! In the ATTENDANCE table I have; Member Name , Event and Status- the status I would like to just be P for present and A for absent- which I type rather than select. The Event field refers to Event in the other table called EVENT.
I would like to have a list of all the members, next to the same event for each member, and then in the status field I can type P for present and A for absent.
So the general layout of the attendance table shoudl look like this;
John Doe----- Fair-------P
and so on...
This is the sort of layout I would like to use for the ATTENDANCE table, I am just having difficulty getting all of the data from MEMBER table so that all of the member names appear in a list, rather than the annoying drop down list which access always gives me!
Please, any ideas, before I have no hair left at all!
The Database is for a marching band, if you are curious!