• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 85
  • Last Modified:

Insert Statement when using a subfor

Can I use a Insert statement for fields in the Main form and the sub form??
0
Jass Saini
Asked:
Jass Saini
  • 2
  • 2
  • 2
  • +1
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What do you mean - you want to INSERT data into a record, and then show it via a Main form and Subform?

Or you want to take data from a Main form and Subform and INSERT that data somewhere?
0
 
Jass SainiAuthor Commented:
Take the data from a Main form and subform and insert into a table
0
 
Eric ShermanAccountant/DeveloperCommented:
Generally you would take the data from the underlying table of the form/subform and insert into another table.  Can you provide a sample of what you are trying to accomplish.

ET
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jeffrey CoachmanMIS LiasonCommented:
Then lets drop the term "Insert Statement"
...and just say: "Take the data from a Main form and subform and insert into a table "

When you specify "Insert Statement", ...you seem to be specifying the exact technology (SQL *Insert statements*, in his case) that you want us to uses, ...despite the fact that there may be other ways to accomplish this...

That all being said, ...I have to ask why you need to do this...?
The very nature of a one to many relationship is to avoid having one table with two different sets of data, ...not to mention the fact that if you do this, you would would create redundant data, (that would need a mechanism for being updated when the source data changes)

The typical way of dealing with this is to make a query joining both of your tables.


So you may wish to restate your ultimate need here, ...then experts can recommended the best way to accomplish this...

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
Here is a sample of a *query* that displays mainform/subform (Parent/Child) data.
(It can be filtered as well)
...but I think this addresses your question here as I understand it...
Database50.mdb
0
 
Eric ShermanAccountant/DeveloperCommented:
I agree, we need an example of what you are trying to accomplish as there's usually a little cleaner way without having to duplicate the same information in various tables.

ET
0
 
Jass SainiAuthor Commented:
Thank You
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now