Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

combining multiple primary keys

Status
Not open for further replies.

papajoeb

IS-IT--Management
Jan 28, 2004
1
CA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top