"Automation" can mean different things to different people.
First, please describe what you want to have as an outcome.
Second, from your description, it sounds like you are storing redundant
information in more than one table ("there are similar columns in those
tables"). If you provide a description of your table structure, the 'group
may be able to offer suggestions that solve your question in ways you
haven't considered.
Good luck
Jeff Boyce
<Access MVP>
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.