Hello, I have been working on an inventory database where I will be tracking all of the transactions (incoming, outgoing, and internal adjustments) for a specific part. Curently, I have Incoming, Outgoing, and Transaction tables that tell when the transaction occured for a specific part. See relationship:
What I am trying to do next is gather all of that information into a report. My plan of attack is having a form that will allow the user to select the PartNumber, Date to go back to, etc. From there I would like a simple report (or table) that lists all of the transactions for the part. If anyone has any suggestions for how to go about this, I am all ears!