This is possible to do natively, but would take more time to explain than I have right now. Please contact me at
www.quickbase.com if you would like 1 on one assistance to set this up.
Basically the idea is to set up a table to hold the Record ID# of the Focus Part Transfer. The user would be sitting on a Part Transfer record and push a URL formula button. That would record the Part Transfer Focus Record ID# and then refresh the record.
Meanwhile, the Focus Record ID# would get looked down to the part Assignments and then would "light up" the Part Assignments. Then the "lit up" part assignments would "light" up the Parts.
Then by the time the record refreshed it would have a correct embedded report of all the Part Assignments for all "lit up" parts. The Embedded report would be set to only display (form rules) if the Part Transfer was in focus.
