Use Data from 2 tables to add Result to third table

[pelagic]

Hi there,

I have 3 tables tblData, tblControl, tblResult

tblData has the follow data:

catdescript (Column name)
1. GPS ACCESSORIES
2. GPS DEVICES
3. BINOCULARS
4. BLANK CD/DVD MEDIA
5. CD/DVD
6. GAMING
7. MP3 PLAYERS
8. RECORDERS-VOICE
9. MEDIA- CD/DVD
10. MEMORY- ADAPTER

tblControl has the following data:
Categories (column name)
1. COMPUTER
2. ELECTRONICS
3. ENTERTAINMENT
4. OFFICE
5. OUTDOOR

How do I display the data in tblResult as following?
CatResult (column name)
1. OUTDOOR
2. OUTDOOR
3. OUTDOOR
4. OFFICE
5. OFFICE
6. ENTERTAINMENT
7. ENTERTAINMENT
8. ELECTRONICS
9. COMPUTER
10.COMPUTER

Data in tblResult is based on the data from tblData, but the actual value is from tblControl.

Any hints or suggestion would help.


Thanks,
pel

 

[dhookom]

Is this a brain teaser? You aren't storing anything in any table that relate tblData to tblControl.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]