Linking 2 Tables or Queries

[vdanelia]

Hello dear friends, I Need your Help

I have one main table [DATA] with fields:
Dealer
ID Autonumber [PK]
Dealer
Product
Brand
Model


Description
Pnumber (Part Number)
Quantity
Unitprice
Priceall
Dateofpurchase

Another table [CODE]

in This Table i have the fields:
SNBCID Autonumber [PK]
DATAID Number [FK]
Snumber
Barcode

I linked the table, but i have a search problem my search system searches in main table [DATA]

how to solve this problem
Tank you in advanced

[orange]

Your tables do not seem to be normalized.
Here are some links to assist with table design.
http://www.utteraccess.com/forum/Sug...d-t373096.html

[vdanelia]

I Just want to know, how to connect (Link) the tables that i could search in both of them

[orange]

I Just want to know, how to connect (Link) the tables that i could search in both of them

Is there a field in each table that relates these tables?
In other words, why should they be linked? What is it you're trying to do?

[vdanelia]

I Solved This