hi guys,
i need to make an events/service purchase database. I have attached an image from excel of what the main form should look like. There is a list of services from the events planner that have a charge depending on what the service is. Each event can have many services. Each customer can have many events. each service can be used unlimited times. (forgot to include in the diagram - tick box for payment recieved, deposit recieved to dat etc. all the payment details)
ive posted this thread here because im not sure where it should be and obviously not post multiple times. My first prob is how the tables and relationships have to be set up. Im not sure on what to include in which tables etc. Ive read up on normalization but it doesn't help. I've tried numerous times, with numerous different set-ups. Ive searched forums and looked through example databases but now im a bit stuck. just want to get some more personalised advice.
Any help would be greatly appreciated.
Also, if anyone has got any good ideas that i can use for the db please let me know too!
Thanks, in advance, for any help you guys can offer me.
James
http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=15527&stc=1&d=1164028181
DB EXAMPLE.zip
i need to make an events/service purchase database. I have attached an image from excel of what the main form should look like. There is a list of services from the events planner that have a charge depending on what the service is. Each event can have many services. Each customer can have many events. each service can be used unlimited times. (forgot to include in the diagram - tick box for payment recieved, deposit recieved to dat etc. all the payment details)
ive posted this thread here because im not sure where it should be and obviously not post multiple times. My first prob is how the tables and relationships have to be set up. Im not sure on what to include in which tables etc. Ive read up on normalization but it doesn't help. I've tried numerous times, with numerous different set-ups. Ive searched forums and looked through example databases but now im a bit stuck. just want to get some more personalised advice.
Any help would be greatly appreciated.
Also, if anyone has got any good ideas that i can use for the db please let me know too!
Thanks, in advance, for any help you guys can offer me.
James
http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=15527&stc=1&d=1164028181
DB EXAMPLE.zip
Last edited:
