Hi there,
Can anyone give me some advice:
I have a sub form on a form - the link fields are specified - 3 different fields.
I actually only need to link to one field which is a primary key but I have the other 2 fields as link criteria so that when I enter a new Record in the Sub-form, it automatically enters the other 2 values in the record.
Which is the "correct way" of doing this
1. Linking the sub forms and master forms so as to insert the link fields in the sub form when entering a new record
2. Linking only the field and entering the other values with procedure like me.other field = me.parent.other field?
Just for the info I have a number of sub forms on one master form and I'm trying to gain some speed on the opening process. The form seems to take a long time to open.
Can anyone give me some advice:
I have a sub form on a form - the link fields are specified - 3 different fields.
I actually only need to link to one field which is a primary key but I have the other 2 fields as link criteria so that when I enter a new Record in the Sub-form, it automatically enters the other 2 values in the record.
Which is the "correct way" of doing this
1. Linking the sub forms and master forms so as to insert the link fields in the sub form when entering a new record
2. Linking only the field and entering the other values with procedure like me.other field = me.parent.other field?
Just for the info I have a number of sub forms on one master form and I'm trying to gain some speed on the opening process. The form seems to take a long time to open.
