Hi,
am kinda new. Could someone kindly help me. I can't figure it out . I'm trying to do a database for a club that contains members and events. I want to have members information and events information which then when a member want to perticipate in any event I could put him in that event and the event should have seats limitation and I can see how many seats are left and also I want to retreive the information that tells me that this member is participating this in this event.

thank you

Here's a Data Model for Athletes and Events on the Database Answers web site that will give you some insight into that part of what you are looking for :-
http://www.databaseanswers.com/data_...etes/index.htm

There are also more than a dozen Models on Reservations and here is one for Cinema Bookings that will help with reservations :-
http://www.databaseanswers.com/data_...ings/index.htm

B.Dimple

thank you very much I appericiate it