If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
One form to multiple tables?
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? -- GD |
#2
|
|||
|
|||
One form to multiple tables?
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 "GD" wrote in message ... 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? -- GD |
Thread Tools | |
Display Modes | |
|
|