The easiest way for that would be to...
Create a Text formula called [Status] in the Restricted Table that is simple like this.
Restricted
Create a relationship from the Restricted Table to the Inventory Table based on part number.
Then create a lookup field to the Inventory Table for the formula field that you made called [Status].
Then go to your Product Ordering Table and create a lookup field to your Inventory Table that pulls that same field you just pulled from the Restricted Table.
Then for some extra flair I would hide the lookup field and create another Rich text formula field that looks something like this.
If ([Inventory - Restricted - Status]="Restricted","<div class='' style='padding: 3px 5px; background: #FF9999; border-radius: 8px; text-align: center;'>Restricted</div>","<div class='' style='padding: 3px 5px; background: #99FF33; border-radius: 8px; text-align: center;'>Available</div>)
Then place the new formula next to the part number in the order sheet and with the Dynamic Form Rules - hide the field unless the field says "Restricted" or "Available" so that you don't have an ugly empty block sitting there until a part is selected.
If i misunderstood I apologize. I hope this helps!
------------------------------
David Hyde
------------------------------