I need to be able to delete the relationship between two tables. Delete a table, which is then recreated by a query and then re-create the same relationship.
Does the above work in access97. I only ask the question because I use 2000 at home and 97 at work, and i'm not at work until next week and want to try it out before then.
