Auto Lookup Query is impossible with Multiple Primary Key???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wem3rd - 20 Mar 2006 15:45 GMT

I have a two table query where Primary Table's single primary few field is
joined to the multipe primary key on the secondary table. The foreign join
field in the second table is not indexed.

The Auto Fill In works fine as data is entered, but the auto filled fields
are not added to the target table when the query table is closed. All the
other new data is properly added to the target table.

I just don't know what else to do.

Thanks for tips.

wem3rd

Reply to this Message

John Vinson - 20 Mar 2006 20:06 GMT

>I have a two table query where Primary Table's single primary few field is
>joined to the multipe primary key on the secondary table. The foreign join
>field in the second table is not indexed.

This is confusing. You cannot join a single field to multiple fields;
and a foreign key field MUST be indexed in order to be a foreign key.

>The Auto Fill In works fine as data is entered, but the auto filled fields
>are not added to the target table when the query table is closed. All the
>other new data is properly added to the target table.

What are the fieldnames and datatypes? Could you post the SQL of this
query?

>I just don't know what else to do.

Typically one would use a Form based on the "one" side table, with a
Subform based on the "many".

John W. Vinson[MVP]

Reply to this Message

wem3rd - 31 Mar 2006 14:41 GMT

> >I have a two table query where Primary Table's single primary few field is
> >joined to the multipe primary key on the secondary table. The foreign join
[quoted text clipped - 17 lines]
> John W. Vinson[MVP]
> The HELP examples provided by Microsoft led me to believe that the foreign key may be "one or more" field columns that refer to one or more key fields in the primary table. Yours is good news, I will rework my efforts and respond with results - hopefully successful ones!

Thank you. (I cannot seem to get MS to send me an email notice when I have
a reponse to my posts)

wem3rd

Reply to this Message