Hi - I've done quite a bit of Googling and reading but can't find a definitive
answer to this.
I would like to have a list of key data rows each with a unique id and some
data.
datarow1 a b cdatarow2 x y zdatarow3 m n o...
I'd then like to have other rows that point to one or more of they data rows
that have a multi-valued field that can contain one or many of the unique id's
above.
User1 datarow1, datarow2, datarow3 etcUser2 datarow4, datarow21, datarow43
etc...
Then i will join from the user1 row to the data row.
My question is simply are there *any* limitation on doing this kind of join? I
believe there are some geo-spatial issues and sorting (i don't need to sort on
the id) but before i jump fully into this approach i've like to understand
anything i may run into - or whether it is better to have them as individual
rows and join them that way.
many thanks,/steven
