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.
 

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

Similar Threads

PK & FK problems in data consolidation 21
how to double click a list box item to add to subform 6
Auto Filling fields in form 7
forms, foreign keys and relational model 1
Find a record based on field on other form using primary key 15
Linking Forms 7
When added a record wil automatically can be chosed in other form 2
Getting Foreign Key from Parent Table for New Record via SQL 5

Back
Top