Relationships

[Aurora]

I am using Access 2003
I created a Database. A couple of the fields I used are "look-up wizards".
But in creating them, I did something wrong because I am not getting the
correct data into my form. So I tried to re-do these fields and I got a
message that because of the Relationship I can not change this without
deleting the Relationship. So I went into tools>relationship and deleted the
two tables listed there. But I still can not make the change and I am still
getting the same message. I went back into tools and relationship - but
nothing was there. What am I missing???

Please Help me if you can - Aurora

 

[Brad823]

Aurora,

You need to actually delete the relationship between the tables - what you
have been doing is removing the tables from the Relationship view.

Go to the Relationships tool, and select "show all". You will then see each
table and their relationships. Right click on the actual relationship (the
black line between tables) and select "Delete."

Now you should be able to re-do your Look Up Wizards.

Brad