Afternoon,
i am returning to access after many years of not using it so please bare with me if some of my answers sound a little stupid.
Scenario - I am currently in the process of redesigning the publicity for a brass band i play in in Scarborough UK. all members think it would be a good idea to have some way of them all being able to commit to our concerts throughout the year. i'm not looking for anything fancy for now but the initial steps are driving me crazy.
I have:
Table one: contains all information about band members, Names, address, telephone numbers ect.
Table two: contains Concert information Venue, Time, Date, information
i need some way of connecting these together for members to be able to say weather or not they are able to attend each of the concerts.
list of names - can you go, YES/NO, simply job done.
can this be done on MS access and how?