AutoKey to ForeignKey

[w0od0o]

just a quick one i hope, whats the best way to het the data from a AutoKey to ForeignKey without having to type it?

i have them in a relationship but cant get them to pass the data down

thanks

w0od0o

 

[Vonnie]

I am not understanding your question.

You have an Autonumber field in one table that is a foreign key in another table?
for instance like in Northwind, the OrderID in the Orders table and OrderID in the Order Details table?
And you want to get the other data from which table?

Maybe you could post the kind of Join you have? or the SQL from a query between the 2 tables?

 

[Rich]

Use a Form with linked subform to enter the data

 

[JANR]

If you have ha form with a subform on it you are already there. Just make sure that you have linked Master->Child relationship properly.

If you look at the property form your subform se if master field is set to your autokey and child-field is set to your foreignkey.

ps hide the foreignkey in your subform so the user don't write or change it.

 

[w0od0o]

got it thanks