Table Comparisons
I have two tables, both of which contain parts inventory information. One table is called "Inventory" and is my master table for parts info. I have another one that each night is pulling parts info f...
Forum Discussion
Right now the key field of the Inventory table is the Part #. The key field of the Temp Inventory field is the Record # but that can be changed if need be. Whatever will make it easiest.
MarkShnier__You
Qrew Legend
Qrew LegendOk, let's say that you change the Key field of Temp to Part #.
Make a new formula text field in Inventory called [Part# mirror for relationship] with a formula of [Part #]
Then make a relationship where one Temp has Many inventory based on that field,
Then make a summary checkbox field on the relationship if there are Any Inventory records.
ok, so now we have a checkbox field on Temp that will be unchecked if the Temp part has no corresponding inventory part.
So now actually, you can make a simple two step Pipeline to trigger when a Temp is created and it has no Inventory, and the next step will be to create an inventory record.
Feel free post back if you have questions.