By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,529 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

tables and the relationship

P: 1
Company make a daily reservation's for a clients to attend a special events (daily events which made every 1 hour starting from 7 pm).
- So we have a daily reservation for many clients.
- And we have sales that make the reservations at the reservation department.
The company collects a reservation fee from every client.
- So we have collections fees.
The company has to call each Clint to make a confirmation with him.
- We have confirmation representatives whom make the confirmations.
- we have a deferent cases for confirmations:
-Ok confirmed (he will attend at same date same time as his old reservation).
-Ok confirmed (he will attend at same date but deferent time than his old reservation).
-Canceled (he will not come at all).
- He will attend but on a deferent date but same time.
-He will attend but on a deferent date deferent time.

Are there anyone could help me setting up the tables and the relationship between them please because I'm not expert on access thank you very much.
Sep 19 '07 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
Please read this tutorial thoroughly: Database Normalisation and Table Structures

Any parts you don't understand, we'll try to help you with, however, we cannot do your work for you!

Regards,
Scott
Sep 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.