Problems with forms / foreign key

[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

[John Vinson]

On Tue, 22 Jul 2003 08:22:26 -0700, "Josh" <jsharpe@cox.net> wrote:

>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.

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.

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?

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]