Problems with forms / foreign key

  • Thread starter Thread starter Josh
  • Start date Start date
J

Josh

I'm still having issues getting my form to automatically
fill the foreign key field. I'm trying to create a data-
entry form - one that creates new records that span
several tables. I would like the foreign key to
automatically inserted to link them up. I have the
relationship set up and I did make sure to set the
Child/Master Field property. Someone please help I've
tried everywhere to find out what I'm doing wrong, I know
it's something really stupid and small.

Please Help!
-Josh
 
I'm still having issues getting my form to automatically
fill the foreign key field. I'm trying to create a data-
entry form - one that creates new records that span
several tables.
Click to expand...

Several tables in a one to one relationship? WHY!? If you have more
than 255 fields and you're trying to do this to get around that limit,
you're going the wrong way about it.
I would like the foreign key to
automatically inserted to link them up. I have the
relationship set up and I did make sure to set the
Child/Master Field property. Someone please help I've
tried everywhere to find out what I'm doing wrong, I know
it's something really stupid and small.
Click to expand...

Well, you'll have to give us some more information. How are these
tables related? What's the Recordsource of the main table? of the
subform(s)? Are you aware that creating a record on the mainform does
NOT create a new record on the subform - that record is created when
you start entering data on the subform, not before?
 
Back
Top