Unanswered: Getting an error message message when i try to cascade updates between two tables
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_ID Autonumber long integer
Program_Category_ID Number Long Integer
etc. etc. etc.
*Program_ID Number long integer
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.