Hi,
I have set up a database for the clubs at my school. It has 3 tables:
Members : fields- Idno, Forename,Surname
Clubs: Fields - Clubid, Clubname
Membership: Fields- Idno, Clubid, Active
I can find information from the tables via queries/forms and reports. I have filled out the Members and Clubs tables but can't find a simple way to input all the initial membership data. I am trying to make a data entry form but can't find a way of doing this. Does anyone have any ideas as to how I can set up a simple form to do this?
So far i have set up a form which shows the membership records ( and can be added to amended ) and added subforms which display the Clubs and Members tables. Unfortunately the Members subform starts with the records in Idno order instead of Surname order, which would be far more useful - I know I can click on the field and re-order it, but the form isn't for me to fill in so it needs to be as easy as possible.
Thanks.
I have set up a database for the clubs at my school. It has 3 tables:
Members : fields- Idno, Forename,Surname
Clubs: Fields - Clubid, Clubname
Membership: Fields- Idno, Clubid, Active
I can find information from the tables via queries/forms and reports. I have filled out the Members and Clubs tables but can't find a simple way to input all the initial membership data. I am trying to make a data entry form but can't find a way of doing this. Does anyone have any ideas as to how I can set up a simple form to do this?
So far i have set up a form which shows the membership records ( and can be added to amended ) and added subforms which display the Clubs and Members tables. Unfortunately the Members subform starts with the records in Idno order instead of Surname order, which would be far more useful - I know I can click on the field and re-order it, but the form isn't for me to fill in so it needs to be as easy as possible.
Thanks.
