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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top