Avoid multiple entry for foreign key

[Alico]

Hi All,

I have a master to child table relation which is one to many. Each one is represented by a different form.

The problem is, the user enters the primary key "JobID" on the master form, then he needs to enter a few records on the child list with the same "JobID" which is the foreign key in that case. I don't want the user to enter the "JobID" every time he enters a new record in the child form.

Is there a way I can copy the primary key to the foreign key each time the user enters a new record in the child form?

Thanks for your help & time.

Regards,
Ali

 

[Uncle Gizmo]

A subform embedded in your main form is the usual approach.

 

[JHB]

Link the main and sub-form together using "Link Master Fields" and "Link Child Fields", (remove the "JobID" control in the subform).

 

[vbaInet]

Look into the Link Master Fields and Link Child Fields properties of the subform control.

 

[vbaInet]

We also made it a threesome... if only Uncle T was a bit patient.

 

[Uncle Gizmo]

>>> if only Uncle T was a bit patient<<<<

Yes ... I jumped the gun there didn't I!

I thought the OP was opening several different forms. In other words, a potentially nightmare situation...

 

[vbaInet]

I was actually supposed to say, "We could have made it a threesome" in reference to the timing of all three posts.

 

[Uncle Gizmo]

"We could have made it a threesome"

Not with me, I'm not that way inclined...

Well Me and two Ladies... Now thats not out of the question...

 

[vbaInet]

Haha! Neither do I.

Keep it clean Uncle T