Attached is a file that demonstrates an example of what I am trying to do. Ideally I envision each person's general info listed (as shown in table called "Main") and then there would be the Color field which would have a table that branches out of it (sort of like there is now but it's in the first column) where multiple colors could be selected. This example only has one field, but the final table will have multiple mutli-value fields, so the pop-out table would need to be associated to it's main column rather than hanging out in the front.
I am also open to ideas that are completely different than the way I tried to present here. So basically, I think the idea is clear as to what I am trying to do, and I am OK with trying a whole different method from my example setup to get there.
Thanks!!!
Start Free Trial
