Stock Management

[rghaddad@inco.com.lb]

Greetings.
I have created a simple stock management database using 3 basic tables:
1- Stock Table
2- Client Table
3- Transaction Table.
I also established the 1 to many relationships: Stock to Transaction & Clients to Transaction
I also created a query that allows me to list all the items that were part of the transaction along with original quantity, transaction quantity and remaining quantity.

I am however unable to list all stock items to include those with and without transactions along with their relevant quantities.

Can anyone help?

Thanks

Roland

 

[CazB]

In the query, you need to set it to show All Records from your Stock Table -

If working in design view, Double-click on the Join Lines and then select the 'Show all records from Stock and only those records.... ' as shown in the example from another db below


If in SQL, specify it as a LEFT JOIN from Stock to the Transaction table, and then a LEFT Join to Customers as well if you're including data from the Customers Table

 

[rghaddad@inco.com.lb]

Thank you for the reply.
This is exactly what was needed.
Roland