doubt with linked tables in access

[samfischer]

doubt with linked tables in access(relationship)

i have imported 5 excel files and linked to a query named stock.i have linked the code,description and quantity from each table (ms excel imported) to stock.
the problem is not all the codes available in the tables r available in stock.there r
more than 25000 codes but only 2614 r listed in stock.i dunno whether its the problem with the way i have linked.so if u can help me with the problem i will be really thankful.
5 excel sheets contains the code,description and qty of 5 shops.in the query stock contains 1st column-id,2nd column-code,3rd column-description and 4th,5th,6th,7th,8th column the qty from 5 excel sheets respectively.i have given the images below of 1st shop(similarly 2,3,4 and 5 r made).the image of relationship is also given.so pls help me.

 

[valheru]

Hello SamFischer

I assume when you say link, that you are trying to build a relationship between the two tables.

I notice that you say you have linked code, description and quantity. Are you using all three of these fields as a link? For me code would be the only identifier which should be common in both tables. Also check the relationship type you are using. Are you using a one to many relationship or a one to one relationship?

 

[neileg]

Not enough information. Could be the use of inner joins instead of outer joins.

 

[rsmonkey]

as valheru said, and I am right in thinking that you have created 3 relationships in your query builder to code,description and quantity. First of all I would suggest you go and read up on normalisation and some general database design especially primarky & foreign keys. all you need to do is link the tables via their Primary & Foreign keys (unique identifiers) and aslong as the identifiers match each other then you should be able to build your query fine. As i sed though read some more on DB design etc..