Hi All..
I am trying to design a database that tracks everytime an employee is intered into the DMV lic confidential system. Here are the tables I think I would need... Scribbles a bunch of stuff on paper and also used the actually form to get information I need....
I have come into a few problems that I don't know how to work out.. They mainly deal with relationships..
The way i was going to set it up was have the main talble and then have a couple of talbes that are related to the main table... Or if I need to have another table in....
I have it setup with the main employee info as the tblMain......with the assumption he/she can have more then one car/one spouse/one child.. this is the part I am getting confussed on......
If you don't mind can you take a look at it..
Thanks again for your help..
R~
I am trying to design a database that tracks everytime an employee is intered into the DMV lic confidential system. Here are the tables I think I would need... Scribbles a bunch of stuff on paper and also used the actually form to get information I need....
I have come into a few problems that I don't know how to work out.. They mainly deal with relationships..
The way i was going to set it up was have the main talble and then have a couple of talbes that are related to the main table... Or if I need to have another table in....
I have it setup with the main employee info as the tblMain......with the assumption he/she can have more then one car/one spouse/one child.. this is the part I am getting confussed on......
If you don't mind can you take a look at it..
Thanks again for your help..
R~