auto complete check box sets - both ways
In an order system for a printing company:
I have a check box set on my primary order ticket layout:
field: Job compents
check box set:
I have second Print Ticket layout with just the information relevant to the printer operator. I would like to display a check box set on this layout that only has the last two options (Inkjet & Flatbed). I would need these two check boxes to auto-complete based on the larger set on the primary order ticket and visa-versa. Different people along the production process may be checking the boxes in either layout.
Both layouts and fields would be in the same table.
Is this something that is possible?