I am working with a dataset that has id lists. So for instance one
table has the following 3 ids -
The tablepk_id is the unique id for that table. The other 2 ids are
actually comma separated lists of adult and child ids, e.g. "adult001,
Now each adult and child also have their own tables where the ids are
regular pk ids (not lists).
So, I will be going back and forth between tables where ids can occur
as lists and/or as regular ids. I am trying to come up with a way to
deal with this. Any ideas?