PDA

View Full Version : [SOLVED:] Linking through code


Kundan
03-11-2019, 08:58 PM
Can we change linking with the subform through code? How?
OBP
03-12-2019, 04:37 AM
What do you mean by "linking"?
Do you mean the Master/Child links with the mainform?
Kundan
03-12-2019, 08:41 PM
What do you mean by "linking"?
Do you mean the Master/Child links with the mainform?

YES!
OBP
03-13-2019, 02:30 AM
It should be possible, but why would you want to?
Kundan
03-14-2019, 12:52 AM
It should be possible, but why would you want to?

I have 2 fields LNAME & FNAME. LNAME is linked to the subform which displays the corresponding address. But there are cases having no LNAME. In such a case I want the AFTER UPDATE event the FNAME to link with the subform to display the address.
OBP
03-14-2019, 02:14 AM
Sorry, but that is poor design.
The master child link should be the same as the Key fields that link the tables, which should be a unique value, usually an Autonumber field or a custom designed value.
Kundan
03-27-2019, 09:30 PM
Sorry, but that is poor design.
The master child link should be the same as the Key fields that link the tables, which should be a unique value, usually an Autonumber field or a custom designed value.


Thanks for your advice. GOD BLESS YOU!!!!!