It is rarely necessary or a good idea to save the same data to more than one
table in a well-normalized design. Can you explain more why you feel your
business situation demands this?
Do you have a question?
Also, Long Subject lines get truncated, So it would be good to keep the
subject line short and put the question or comment in the big white space.
Use a subform and a form, linked by DepartmentID. It will save the
changes to both tables if your database is structured properly.
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.