Automatic fill for the foreign key, now just number

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

Formerly I was informed that Autonumber PK in the mainform will be
automatically populated in the subform FK ( child records).

Now for somer reason, my memberID, I have changed it to be just number
format. My question is can it still be poulated in the child records? sub
form, because I have a member form, and on another part/tab there is a note
which records the notes for this member which is a subform. So I need it to
work too.

I apprecate for any idea.
 
Hello,

Formerly I was informed that Autonumber PK in the mainform will be
automatically populated in the subform FK ( child records).

Now for somer reason, my memberID, I have changed it to be just number
format. My question is can it still be poulated in the child records? sub
form, because I have a member form, and on another part/tab there is a note
which records the notes for this member which is a subform. So I need it to
work too.

I apprecate for any idea.
Click to expand...

The Subform's Master/Child Link Field will fill in the child record, no matter
what the datatype of the Master Link Field might be. It has nothing to do with
the field being an autonumber; if the main form has a value, it will be
inherited on the subform.
 
Back
Top