Id

Hello...

I have just inserted a tablerow and the table has generatde a primarykey.
this key would i like to get and use as a secondary key in another table.

What is the best way to do this?

is it just to make a select question and ask for the highest id??

/Ciliax

In a second table, you have to have the same fieldtype (just a number field, long integer, and not an autonumber field) and link them together in the relationships window to guarantee relational integrity. Then, you can select the ID number in a query and this will guaranty the right records are related between table 1 and 2.