Need Assistance creating a reference between an Enum list and a table


First post here, just wondering if someone could point me in the right direction,
I have a table with a completed product database, The Product Identifier [Unique ID], I have set up in a separate table called “Roll Picking for Certs”, I have a column called “Assigned Rolls”, The Unique ID’s are now a dropdown for anything with the status “ready for dispatch”, This allows me to choose 1 or many different [Unique ID] to assign to that Sales Order.

Now that all works great and as intended but I would like to mark a field on the Product Database “Roll Database” with the assigned Sales order if that specific ID is chosen in one of the ENUM list values

Is this possible?

Best regards,

Can you share screenshots and elaborate your issue a bit more? Thnx.

1 Like