howdy, i'm kinda new at access and what i'm trying to do is combine the primary keys from several tables to create a unique key that identifies all the connections and is searcheable. basically i'm trying to do like industry code so if i choose field 3 in my first table the first number in my final key code is three... field 6 in the following table gives me 36 so far... field 4 in the next table gives me 364... so that when i'm done, i have a number like 3657 which will be unique to a field.
Basically i'm tyring to icorporate all this into a form to make it really user friendly with dropdown boxes slowing drilling down to find a specific item in a large pool with many catagories.
i'm using the latest version of access for xp. i've got it so that what you select in the first checkbox narrows down the available option in the next checkbox and so forth, but i cant figure out how to combine all the numbers together to query the final table.
any help would be appreciated.
thanx a ton
joe
Basically i'm tyring to icorporate all this into a form to make it really user friendly with dropdown boxes slowing drilling down to find a specific item in a large pool with many catagories.
i'm using the latest version of access for xp. i've got it so that what you select in the first checkbox narrows down the available option in the next checkbox and so forth, but i cant figure out how to combine all the numbers together to query the final table.
any help would be appreciated.
thanx a ton
joe