I’ll try and explain my question.
I working on a collecting app that allows you to select items from a catalog and place them into your collection, I’m stuck on one concept though.
I have a catalog of “groups” that have sets of grouped pieces “Red Box Set” and “Yellow Boxed Set”.
Then I have a catalog of pieces that can reference back to the group they are part of.
Lastly I have a “Collection” table that I want to populate from the available entries in either the catalog of “Groups” or “Pieces”. I can make a REF column to one or the other but can I make that REF dynamically switch based on a selection of which table to reference?
Something like switch the “Source Table” in reference based on a Enum?
Thanks all for any ideas about how to solve for this!