At least it seems strange to me.
I have a customer_main table with all the usual stuff plus a column named
agent. An inherited table from customer_main has a couple of columns
describing each agent.
I need to make sure that a valid id from the inherited table agent is
populating the agent column in customer_main. Any ideas on how to do this? A
RESTRICT constraint from the customer_main.agent column to the
customer_main.id column just seems strange for some reason. Is this the right
solution?
--
Lewis Bergman
Texas Communications
4309 Maple St.
Abilene, TX 79602-8044
915-695-6962 ext 115