I can cascade deletes and enforce ref. integrity with no problems between these two tables but when i enable cascade update related fields i get the following error message

"Invalid field definition 'Program_ID' in definition of index or relationship. "

here is the design of the two tables

"Program_Info"
*Program_ID Autonumber long integer
Program_Name text
Program_Category_ID Number Long Integer
etc. etc. etc.

"Program_Info_Products"
*Program_ID Number long integer
Card_Products text
Reward_Currency text
I-net_Utilization text

right now referential integrity and cascade on delete is active but i cant enable cascade on update Program_ID <-> Program_ID.

When i get the error message "Invalid field definition 'Program_ID' in definition of index or relationship. " It is referring to the table Program_Info. I narrowed that down by slightly changing the name of Program_ID in the table Program_info_products.

Thanks in advance for any help you give.