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

[Guest]

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

 

[John Vinson]

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]

 

[Guest]

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.


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


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

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