Table Joins 1

[MrArmstrong]

I have four tables that I have data in.
I have my 1Stock Inventory table
2Purchase hold table
3Purchase Request Table
4Purchase Order Table
i am linking the tables from #4 down , they each convert to the other. On the Purchase Order Table I link conv doc to Purchase request doc #,then i link conv doc # on Puchase request Purchase Hold document #, then I link Purchase hold table to inventory by part number. My problem is that I can see All orders that either started from inventory and went all the way through to a Purchase order or inventory items that have no action at all.

I need to know what kind or where do i fix my joins to show the few that Have a Purchase order and Purchase Request but didn't come from a Purchase hold document or part in the inventory.

 

[MrArmstrong]

I'll try that one but here is another one, I have a formula subtracting the Purchase Request enter Date from the PO enter date , how can I change this formula to also fill in the Gaps on the lines that have PO_1 data.

 

[MrArmstrong]

I have check ove my data and everything seems to be fine with the PO fields now. I seem to be missing a few records that are Inventory--> to Hold Doc-->Purchase Request,with No PO created yet. the Purchase request is not showing up.

 

[MrArmstrong]

This is complete now thanks for the help.