I have 9 regions. Within each region there are 50 odd councils. Within each council an employee is given a certificate number which is unique to that region.
For example, if the council is in Region 1 the employee gets given GO1/1, the next person in that region gets GO1/2, etc. In Region 2 it would go GO2/1, GO2/2 and so forth.
Whats the best way to design the tables and relate them. At the moment I've got one table for the Regions and created separate tables for each region with the relevant ID autonumber (GO1/, GO2, etc) on each table. I 've then related them by a 1-many.
To input the info I planned to a main form with a combo fox for the regions and when you select the region the relevant subform appears.
Is this the bes way to go about it bearing in mind I'll need to do queries etc.
Thanks
For example, if the council is in Region 1 the employee gets given GO1/1, the next person in that region gets GO1/2, etc. In Region 2 it would go GO2/1, GO2/2 and so forth.
Whats the best way to design the tables and relate them. At the moment I've got one table for the Regions and created separate tables for each region with the relevant ID autonumber (GO1/, GO2, etc) on each table. I 've then related them by a 1-many.
To input the info I planned to a main form with a combo fox for the regions and when you select the region the relevant subform appears.
Is this the bes way to go about it bearing in mind I'll need to do queries etc.
Thanks