It sounds like you want the value in the child table to match one of the columns in the parent table. Can you explain the business case for this? You may be offered another solution for this that works better.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question