Suppliers Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm new to Access so excuse my lack of expertise I'm designing a database
with 4 tables Suppliers, Products,Customers and a Returns table the first
three I,ve imported from a speadsheet the Returns table is inputed data from
the other three the problem I have is I can get information from
Product,Customers and returns but when I enter the supppliers tbl in the qry
it gives nothing.
The imported product tbl has 12,000 records but no Supplier ID this was
missing on the speadsheet, can I get this information without having to input
the Suppliers ID in the products tbl
 
What tables are joined and what fields are they joined by? If the any table
doesn't have a field to join to another table, you will not produce any
valid results.
 
Chris,
I have
Suppliers tbl "supplier id" to Product tbl "supplier id"
Product tbl "product id" to Returns tbl "product id"
Returns tbl "account id" to Customer tbl "account Id"
I only have Suppliers ID (188 records) in Suppliers tbl
 
Suppliers tbl "supplier id" to Product tbl "supplier id"
Product tbl "product id" to Returns tbl "product id"
Returns tbl "account id" to Customer tbl "account Id"
I only have Suppliers ID (188 records) in Suppliers tbl
Click to expand...

Well, if you don't have the Suppliers ID populated in the Product
table, how can Access (or anyone!) determine which products are from
which supplier!?

Maybe I'm misunderstanding; could you post a couple of rows of sample
data from the two tables?

John W. Vinson[MVP]
 
Back
Top