M
MB
In my table is a field in which I used the look-up wizard to look up items in
a separate table. I did this to the wrong field and want to make it a plain
text field instead. I tried removing the row in the design, but I'm getting
a message that says there is a relationship and I cannot remove or change it.
I've removed all relationships to the table and query (there's only one),
but still can't remove or change that field.
What am I doing wrong (besides using look-up which I just found out by
reading these posts that I should not use it)?
Thank you!
a separate table. I did this to the wrong field and want to make it a plain
text field instead. I tried removing the row in the design, but I'm getting
a message that says there is a relationship and I cannot remove or change it.
I've removed all relationships to the table and query (there's only one),
but still can't remove or change that field.
What am I doing wrong (besides using look-up which I just found out by
reading these posts that I should not use it)?
Thank you!