Table Problems

[jwr]

I have a database based upon the Access Order entry template. I have
tables --
Customer
Orders
OrderDetails
Products
Dealer
ShippingMethod

When I create a query based upon; i.e. customer id, order id, ship date,
dealer name, -- I get no info for the dealer. The customer id (which is
autonumber primary key in the table) displays with the customer name --
which is another field in the customer table.

Why does this display different that the table?

Also, if all of this info is coming from the orders table, the info is
correct. If I add the dealer table to the query, I get no info. I have the
dealerid linked to the dealer id in the orders table. If I delete dealer
table, I get info, but with name instead of id number.

Help please.

 

[Arvin Meyer [MVP]]

You have problems caused by the use of Lookup Fields within a table instead
of using joins in a query:

http://www.mvps.org/access/lookupfields.htm

I suggest that you go into the table's design view and copy the Select
statements to Notepad, then delete those Select statements from the tables.
Then build queries using joins of both tables (perhaps using the very same
select statements) and base your data entry on those queries.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access