I am using Access to connect to my VB. I have a table where the primary key is declared as AutoNumber. Now I need to make this primary key (which Access automatically generates after i've inserted a record) refer to another tables field as a foreign key.
i was checking for responses but i've no idea why i've not received your post earlier until now ...
I'm using Access 2003. I've already made the relationships but how do i tell the new table which value has to be the foreign key. I mean if there are supposedly the values 1 and 2 (of a primary key of the first table), how do I tell the second table which of these values is the foreign key for the current record.
No, I am not talking about field names but the value that the field holds. As I already said I did make the relationship but what I needed to know was "how to insert a value of a primary key to another table as a foreign key".
P.S. The primary key is automatically generated (AutoNum)