I have following tables: OWNER --- SERIES --- NUMBERS
I have tried to relate OWNER to SERIES and NUMBERS to series, but it doesn't seem to work out for me the way I want...
I would like one unique NUMBER to be linked to one OWNER (one OWNER can though have many NUMBERS, but not the same as a other OWNER) in one SERIES.
Example SERIES 1: has NUMBER 1,3,7 and 8 linked to OWNER "Scott". The rest of the NUMBERS could be linked to the other people in the SERIES 1, but it has to be NUMBERS that I can "choose" for each OWNER and the NUMBERS can be anything from 1 to 1000 (you could almost say randomly NUMBERS). In SERIES 2: It could be just as SERIES 1 (SCOTT has 1,3,7 and 8) but it all depends on what NUMBERS I choose for the OWNERs at this SERIES, it's almost like a lottery with different days or weeks..
I have tried with portals, self-joining tables and calling the support in Sweeden (they just said it was to advanced for them)... I can't figure out a solution..