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

[Lee_Easeman]

Hi!

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,

[LeventK]

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