Many to many relation. How?

Ralf Sander ralf at end-if.de
Tue Dec 7 01:28:19 CST 2004


In FileMaker, a many to many relation can be build by storing many 
related values in one record separated by returns.

e.g.
tablea, field "ids"
record 1:
id1
id2
id3




tableb, field "id"
record 1:
id1
record 2:
id2
record 3:
id3

questions:

1. Is this possible in v, too?
2. How will the select statement look like?
3. In FileMaker, there exists a limitation for the lenght of a single 
relation string (32 bytes, I think) Is there a limitation in Valentina?
4. How can I produce save unique values in a server invironment?

You will say: Use object pointers and a third table, but that does not 
produce save ids. If I delete a record in table b, another record will 
take it's place, right?

Thanks,
Ralf




More information about the Valentina mailing list