Hi,

I made a query to a table and then based a lookup filed on that query.
Now when I refresh the table I do not get the relationship error - you
can't delete table cause relationship is present - instead the table
gets refreshed and the query holds the relationship with other tables.

Problem
As far as I know this works fine.If there is a better simpler way
please advise.

Also, the query is used as a list box in other tables now to look up a
list of names sorted ascending. When I use this query lookup in form
the form displays this as a list box - I'd prefer it was not and just a
single text box - how is this done?

Thanks in advance