How to get rid of erroneous FK notations

E

eagle

When adding relationships to tables, they erroneously got connected to the
wrong fields, so in the child table, the id field is showing it as fk1, fk2,
fk3, fk4, etc. I have since deleted the relationships where there was no
relation at all, but the fk2, fk4 notation is still there on the id field.
How do I get rid of that? All my connections are correct, so it's not
related to anything else. I tried removing the relationship, and when it
says Remove frm underlying source, I said Yes but then it removed the entire
ID field! So I don't want to do that. What do I do?

Thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Denormalize data into one single field (by query) 2
Splitting FK lists on to new lines 0
multiple key fields in parent table and combo boxes for foreign ke 8
Purist or Pragmatist 5
VBA works in orignal but fails in copy of database 1
4 Fields PK linked to 1 field FK 9
Get Rid of Relationship Among "ID" fields 3
Many (City) to Many (Zip Code) help 8

Top