Foreign key reference to a view column

Hello,

Can someone help me with the following:

I recently had to modify a customer table by adding a version column next to each customer number. This to allow tracking changes of customer information.

Other tables refered to the original customer table with a foreign key reference on the customer number.

Now I have made a view on the new customer table so that only the highest customer version is shown, thereby simulating the original functionality.

The problem is that the original foreign key constraint cannot be used on the view so my application can't validate customer numbers anymore.

How can I simulate a foreign key referencing a view column?

Has anyone encountered a similar problem?

Thanks,

Gian Franco

-- 
Direct access to this group with http://web2news.com
http://web2news.com/?comp.databases.oracle.misc