Problem with Foreign key

I have this problem:

when I create a new table and I link this with a other previously created, I get that over the key I was transferred also the foreign key. how can I fix this?


Try the FK mapping feature. Simply double-click on the relationship and then goto Foreign Keys tab. Highlight the child attribute you like to change and hit F2 key. Then simply select the desired attribute from the dropdown.

For more details on keys, relationships, FK mapping, please see the Help file. Use the Index tab and type the key words (key, foreign keys, fk mapping).