Windows 2K 
Access 2003
I apologize in advance for my newbie-ness to MS Access, but I am trying to design a database for a school project and have no background in MS Access other than a book I bought and things I've read on the interweb (that's a joke). And am not having much luck. Hopefully this will help.
Anyways, it seems I'm having a basic technical problem. I know all the tables I need to fill, but am having an issue trying to create the relationships between the various tables. Basically it is a company employee database that is looking to monitor various training(s) needed by each particular job-title. So I created an "employee table" with all their personal info and am now trying to create a 1-to-many relationship with the "training table" -which lists all the various training types and several other tables.
My question is in regards to the best way to create the 1-to-many relationships of the various tables to the employee table. My understanding is that way to do this is use an "auto number" text format in the "parent" table and then use the number-format in the "child" table to create the relationship-link? Is this a correct assumption?
However, when I use the autonumber text-type in one parent table, and then start another table that I want to link to the "employee table" and use the autonumber text-type in another "parent table" again the same numbers are given and so there is no "unique" number to distinguish between the various tables.
Is there a way around this? I read something about creating a query to start the autonumbering at a different number, but that seems excessive? I also thought about using the "random value" text type under autoformat, but then I am given big long numbers that would need to be cut and pasted to create the relationships for each field -and that seems a bit tedious. Is there a simpler way? Is the autonumber-to-number text-type the only way to create a relationship? Any advice would be greatly appreciated.
-Cheers!
Reply With Quote
Originally Posted by orange
