-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Monday 2007-09-17 at 11:58 +0100, G T Smith wrote:
Do you understand the problem now?
I understand the problem.
I have a form with a sub-form linked via an index... Whenever I select an entry in primary form I see all relevant entries linked in the sub-form... Can edit and update records in both form and sub-form...,
Hum! I tried via forms, but I couldn't get it right.
Table structure is roughly
Table A
Index, data
Table B
Index, Link to A index, data
Form to Sub form relationship based on linking field 1 to field 2...
Your structure implies a read only join...
Huh? Rekall does it read write just fine. It shows like this: Title Author ------------------ --------- Robots and Empire Asimov ^ Rendezvous with Rama Clarke ^ The "Author" column fields are drop down lists from which I can choose an author from any author in the authors table.
Adding a new subform entry is clunky... and adding primary entries is definitely very clunky indeed (when committing a new entry tend to keep ending up on first record in table, so you have to go to the last entry and continue from there).
Mmmm... - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFG7wHTtTMYHG2NR9URAhvCAJwMdb+v/gMEio1jDX6Gs+2kHucIaACghzQg XR5k75gBrWZ9/y52wuqRc3E= =y9Y3 -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org