### Title

PROBLEMS!!

### Post

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..

Please, help?!

Series -< Numbers >- Owners

If so, it should be quite simple: In the Numbers table, define fields for SeriesID and OwnerID, and make your two relationships:

Series:: SeriesID = Numbers:: SeriesID

Owners:: OwnerID = Numbers:: OwnerID

Note:

In the Series table, SeriesID is a number field with auto-entered serial number. In the numbers table, SeriesID is just a number field. Similarly, In the Owners table, OwnerID is a number field with auto-entered serial number, and in the Numbers table it's just a number field.