I'm having problems today getting my head round a new DB.
Basically the database will power nightclub guestlists.
So far I'm thinking 3 tables...
Town
Club
Customer
I need to be able to add new towns and clubs on a weekly basis (no problem).
When a customer phones to book I need to I need to enter onto a farm their booking details.
Therefore I envisage the first field being a combo box with the town, that then limits the selection in the next combo box to the clubs in that town which I select and then just enter the customer details.
It's the combo box thing and table structure that is giving me problems, I know I'm going to be using Cascading Combo boxes and I've read a lot about it but I can't seem to get my head round it
Any advice would be appreciated.
Basically the database will power nightclub guestlists.
So far I'm thinking 3 tables...
Town
Club
Customer
I need to be able to add new towns and clubs on a weekly basis (no problem).
When a customer phones to book I need to I need to enter onto a farm their booking details.
Therefore I envisage the first field being a combo box with the town, that then limits the selection in the next combo box to the clubs in that town which I select and then just enter the customer details.
It's the combo box thing and table structure that is giving me problems, I know I'm going to be using Cascading Combo boxes and I've read a lot about it but I can't seem to get my head round it
Any advice would be appreciated.
