So the question is - Why doesn't the foreign key get
automatically insertted? :(
<jsharpecox.net> wrote:>-----Original Message-----
>On Wed, 23 Jul 2003 06:58:08 -0700, "Josh"Integer and>>>>I never said it's a one-to-one relationship
>Pardon my misinterpretation!
>>Name / City
>Is PeopleID an Autonumber? And People.AddressID a Long***Yes and Yes, they're both defaults***>Address.AddressID an Autonumber?the>>>>So I create an Address form that only has a City and a
>>State field. Then I create a People subform(datasheet
>>view) and stick it into the Address form.
>>>Then in the People properties of the main form I saidthrough old>>>Link Child/Master fields to AddressID.
>>>>As far as I know that's all I needed to set up.
>>Apparently I'm missing something.
>That all looks correct to me! I'll have to go diggingeasier if you>messages to find your previous message (hint: it's a LOTnew thread) to>reply to a message in a thread rather than starting aanything you've>find out exactly what's happening, but I don't see>done wrong!
> John W. Vinson[MVP]
> Come for live chats every Tuesday and Thursday