Hi all,

I am a little confussed I have not done Datbase in ages and just want to clear somthing up.

if you have table that has primary key let say
transactionID waht auto increment

Then you have another table that use this as a foreign key am I right in thinking that it should get the value from the first table and store it into the second one?

so lets say
table one
transaction id = 10
name = blar

table two
id = 1
transaction id =10
address = blar blar

that way you can link everything together with the transaction ID

thanks in advance

Yep, it's (almost) that.
The foreign key enforces that the value you put in table2 must exists in table1 at the moment of the insert.

So no, it don't get the value or copy it from table1.
You provide it upon inserting/updating, and the db check at that time it's there in the parent table.