Relationship Problem

[hawzmolly]

I made a mistake when I created my db that I need to correct. There are about 5000 entries now and I don't relish the idea of re-doing the whole thing. Here goes.



I have a db that I need to correct to ensure my tables will work with each other. Table 1 has Field Name [ServiceType] - Data Type [Text], Table 2 has Field Name [ServiceType] - Data Type [Number]. These two fields are the same data but are entered from two different forms that perform two entirely different jobs.

I want to change table 2 Data Type to "Text". I get an immediate error message that says I can't do this because there are relationships between the two tables and I need to delete this or these relationships before I can make the change. When I click on the "Tools - Relationship" tab I get a screen that indeed has the relationship. I delete the line between the two tables close and save the change. Then I try to make my change and the error message returns. I checked the relationship screen again and find that the change I made is ok.

What am I missing? Is there another path to the relationship screen I should be looking for such that I can make the relationship changes and therebye make the table changes?

TIA - You guys are a great help!!!!

[RuralGuy]

You probably have used the relationship in a query somewhere.

[hawzmolly]

Rural Guy - Thank you very much. I am just a 68 year old newbie, but I like learning new stuff everyday.

[RuralGuy]

Well from this 64 year old not so newbie, you're very welcome.

[hawzmolly]

and the young'uns still need our help!