Linked subforms

dsinclair999

New member
Local time
Today, 23:21
Joined
Jan 6, 2013
Messages
5
Hi all, I'm hoping someone can help me out here, its doing my head in. :banghead:

I have a small database, which consists of three linked subforms.
Docid, Revision, Distribution
The Revision is linked to the Docid in a one to many relationship, which is fine.
I would like the revision to be linked to the distribution by a one to many relationship as well (but also linked to the Docid in a one to many relationship as well).
Now my existing wording is:
Link Master Fields [DIDocumentIssue Subform].Form![Revision]
Link Child Fields Revision
which doesn't quite work.

Can anyone enlighten me as to the correct terminology for the statement which should also include Docid somewhere, just not sure of the terminology!!

Regards
DS
 
Without seeing your form it is hard to advise but multiple fields can be included in the LinkFields separated by semicolons. Both Master and Child must have the same count of fields.

When linkng to a another subform it is best to place a textbox on the main form with the ControlSource being the field in the subform then use that textbox as the LinkMaster for the other subform.

Otherwise there can be problems with the loading of the form.
 
[FONT=&quot]Thanks Galaxiom,[/FONT]

[FONT=&quot]Thoses pointers you gave helped a lot, works fine now.[/FONT]

[FONT=&quot]I just had to modify my statements from this:
[/FONT]
[FONT=&quot]Link Master Fields [DIDocumentIssue Subform].Form![Revision][/FONT]
[FONT=&quot]Link Child Fields Revision[/FONT]

[FONT=&quot]to this:[/FONT]
[FONT=&quot][FONT=&quot]Link Master Fields [/FONT][DIDocument Subform].Form![Docid];[DIDocumentIssue Subform].Form![Revision][/FONT]
[FONT=&quot]Link Child Fields Docid;Revision[/FONT]

[FONT=&quot]Regards[/FONT]
[FONT=&quot]DS
[/FONT]
 
Drat, spoke too soon!!
If the document number is changed, it is not updated in the distribution table, but the revision table is updated ok!!!
I've attached the database and would appreciate any help with it.

Regards
DS
 

Attachments

Users who are viewing this thread

Back
Top Bottom