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