Referntial Integrity of Fields

[samusa]

Hi
Could any one tell me how to make referential integrity between fields. Suppose I have a field A which is associated with field B. If I want to delete Value of field B, It shouldn't allow me.
I appreciate your help

Sam

 

[Tigerlili3]

You must do this in the relationships window under Tools-->Relationships-->. You should have relationships already established, but if you do not, you will need to add the tables and create the relationships. When you do, the dialog will give you the option of enforcing referential integrity if it is an option for the tables you are joining.

 

[samusa]

Thanks for your reply. In my case both fields belong to same table.

Sam

 

[PHV]

A self join ?
You may declare such relationship in the aforementioned window, provided you insert the table twice.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886