Having Problem With New Inventory ADD Feature,Blank Records,DLookup Not Right

[burrina]

I have finished about half the db for Inventory and Purchase Orders. With my brain, that's impressive!


I am using the same Products table to reference on for Inventory.

I don't believe my Relationships are correct since my Table does not display the correct data.

The Form I am using uses both the Products table and the OrderDetails table and together they can show me everything.

Trying to use 2 different form to both add and subtract from Inventory.
Subtract works fine and shows what the customer has bought and all.

Purchasing, i.e. Buying Products has proved a challenge for me.

I thought that if the relationships were correct, when you added 2 or more tables, they linked by themselves?
If you change the relationship in a query, does it then change it in the Relationships?

[Rod]

If you change the relationship in a query, does it then change it in the Relationships?

No, they are entirely separate things: tables are related such that the RDMS (relational database manager) may ensure data integrity. Tables are joined in a query for the purpose of interrogating and retrieveing the data. Access uses the db relationship (if any) to suggest a join when first designing a query but you may change or delete that suggested join; you may also add joins where associated relationships do not occur in the db.

I'll now take a look at the wrong concern.

[Rod]

The join in your query looks very suspicious! Do you really mean to join OrderID to ProductID?

I notice a questionable construct in your db design. You have in your OrderStatus table the ID, OrderID(?) and Status. Normally I would expect only the ID and Status to be in the table with the ID being included in the Order table as a foreign key.

[burrina]

That would be that I need to track the status of each order is why!
It is done this way because of my need to run Reports with that criteria.

Thanks,