This may seem like a very basic question but what is happening is not what I expected, as follows:

Table1
Client_ID Primary Key


Table2
Policy_ID Primary Key
Client_ID Foreign Key constraint


I expected that when I added a record to Table2 its Client_ID field would be automatically
populated with the Client_ID from Table1.

This is not happening - Client_ID value remains null.

I am using D7, what am I doing wrong or do I need to turn on (whatever) or
is my understanding just incorrect.

Thanks....



[Non-text portions of this message have been removed]