Can I make an Outer Join a one way relationship?

[johnjmcnaughton]

I spent quite a bit of time working out the calculations. They look good now. The amount in inventory is shown on the "Products" Form.
Here is an example:



Also note that there are two transactions... the first transaction has 3 ordered and 3 received. The second transaction has 8 ordered and none received. This puts the count at 3.



I am not interested at this point in changing the functionality of the database or starting over with someone else's version of inventory. I just want to understand the "Right Join" relationship and how to manipulate it so that when creating a transaction in "inventory transactions" it does not create an unnecessary purchase order. (Nothing is being purchased with that transaction. Just reducing inventory.)
All I want is to be able to document the items that have been used. The "Products" Form already calculates what is in stock.

[johnjmcnaughton]

Perhaps this might help you help me.....

When creating a transaction in inventory transactions..... to reduce the inventory count of an item..... if I leave the Employee field blank it DOES NOT create a purchase order for that transaction. THAT IS EXACTLY WHAT I WANT TO HAPPEN! I have a record of the item being used, the date, description. Everything except which employee created the transaction.

But, of course, I would like the employee to be able to enter their name so we have a record of who used the item. This is where the question comes into play. The Join seems to be centered around EmployeeID. Everything in that Query is pulled from "Inventory Transactions" except for "EmployeeID" which is pulled from "Purchase Orders". This you can see in the jpeg in Post #12 and in the Record Source in Post #6.

How can I manipulate the Join to accomplish this??????

[orange]

Can you post a jpg of the most recent tables and relationships?

[johnjmcnaughton]

Does this show everything you need to see?

[orange]

I don't see how you could manipulate the join to do what you want. Have you done any googling or reviewed any other data models that deal with inventory, reorder levels etc. to see what others have "designed"?

Here's one that may give ideas. http://www.databaseanswers.org/data_...tail/index.htm

Did you read the Allen Browne article? http://allenbrowne.com/appinventory.html