Why do you need more than one table? Wouldn't it be simpler if you use a logical field to flag each account as active or not? And therefore use a query on the flag when displaying/editing active records instead of the raw table?
This might have another advantage if you had related data in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.