Relationships

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aurora - 25 Jul 2006 20:21 GMT

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

Reply to this Message

Brad823 - 25 Jul 2006 21:52 GMT

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

>I am using Access 2003
>I created a Database. A couple of the fields I used are "look-up wizards".
[quoted text clipped - 7 lines]
>
>Please Help me if you can - Aurora

Reply to this Message