One form to multiple tables?

[GD]

Is it possible to link data entered into one form back to multiple tables
without using subforms? Or are subforms required to do this?

I have a form that contains quite a bit of information. Specifically,
though, each record has the potential of having multiple comments from users
at any given time. I'd like to bind the comments (+date, +user) back to a
different table than the rest of the form. Can this be done?

 

[Jeff Boyce]

It sounds like you might be trying to work from a form to the tables.

In MS Access, you start with the tables, then build forms to display the
data.

One reason for using a main form/subform construction is to display
(add/edit/...) data that is related as "parent to children".

Describe how your data is related to get more suggestions on how to design
forms to support it...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[paul23]

You really need to seperate the comments into a seperate table as this suggests a one to many relationship.

Then you would have to use a subform for the comments linked via the primary/foreign keys of the relationship.

-------------------------------------------------------
For your FREE Access beginners ebook

http://www.access-databases.com/ebook

-------------------------------------------------------