Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-29-2018, 06:54 AM   #1
vagues0ul
Newly Registered User
 
Join Date: Sep 2018
Posts: 103
Thanks: 18
Thanked 2 Times in 1 Post
vagues0ul is on a distinguished road
save data from two forms into one table

I have two tables TABLE1 & TABLE2. Each have different elements. I have created a from with values from these two forms and want to store the data into another form. How to achieve it ?

Table1 = Name, division
Table2 = BookName, Author

Table3 is where i need to store the data from table1 and table2.

vagues0ul is offline   Reply With Quote
Old 10-29-2018, 07:00 AM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,284
Thanks: 13
Thanked 4,111 Times in 4,043 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: save data from two forms into one table

Are the tables related in any way? Normally you wouldn't store duplicate data, you'd just retrieve the data as needed from the first two tables.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 10-29-2018, 07:47 AM   #3
vagues0ul
Newly Registered User
 
Join Date: Sep 2018
Posts: 103
Thanks: 18
Thanked 2 Times in 1 Post
vagues0ul is on a distinguished road
Re: save data from two forms into one table

Quote:
Originally Posted by pbaldy View Post
Are the tables related in any way? Normally you wouldn't store duplicate data, you'd just retrieve the data as needed from the first two tables.
yes the tables are linked and they are on a form. i want the save button to submit the data into table3 with the values present on the form (that is created by inserting values of table1 and table2)

vagues0ul is offline   Reply With Quote
Old 10-29-2018, 07:50 AM   #4
mike60smart
Newly Registered User
 
mike60smart's Avatar
 
Join Date: Aug 2017
Location: Dunbar, Scotland
Posts: 439
Thanks: 21
Thanked 90 Times in 89 Posts
mike60smart will become famous soon enough
Re: save data from two forms into one table

Hi

Can you upload a screenshot of your Relationship window showing all fields in the related tables?
mike60smart is online now   Reply With Quote
Old 10-29-2018, 08:26 AM   #5
vagues0ul
Newly Registered User
 
Join Date: Sep 2018
Posts: 103
Thanks: 18
Thanked 2 Times in 1 Post
vagues0ul is on a distinguished road
Re: save data from two forms into one table

Quote:
Originally Posted by mike60smart View Post
Hi

Can you upload a screenshot of your Relationship window showing all fields in the related tables?
here you go
Attached Images
File Type: png relationship.png (12.6 KB, 26 views)
File Type: png form.png (16.0 KB, 15 views)
vagues0ul is offline   Reply With Quote
Old 10-29-2018, 08:32 AM   #6
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,432
Thanks: 165
Thanked 1,737 Times in 1,706 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: save data from two forms into one table

? I'm confused. What happened to
Quote:
Table1 = Name, division
Table2 = BookName, Author
Your fee table doesn't look very normalised , it's not normally a good idea to store data in field names.

So fields called Jan, Feb, March etc. will cause you quite a lot of problems later on. Just think how you will add up the total for instance. Simple in excel, much more awkward in Access.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 10-29-2018, 08:34 AM   #7
mike60smart
Newly Registered User
 
mike60smart's Avatar
 
Join Date: Aug 2017
Location: Dunbar, Scotland
Posts: 439
Thanks: 21
Thanked 90 Times in 89 Posts
mike60smart will become famous soon enough
Re: save data from two forms into one table

Hi

From what I can see you have to study Table Normalisation.

Your Fee table should NOT have a field for each Month.

You would need a field named "MonthsID"

You would need a table which contains a list of all Months.

Then on your Form for Data Input you would have a Combob Box whose Record Source would be the values from your List of Months tables.

You are Linking FeeID - Autonumber to a field in your Batch table which does not have an Autonumber Field. Is BatchID a Number Data Type?

mike60smart is online now   Reply With Quote
Old 10-29-2018, 09:00 AM   #8
vagues0ul
Newly Registered User
 
Join Date: Sep 2018
Posts: 103
Thanks: 18
Thanked 2 Times in 1 Post
vagues0ul is on a distinguished road
Re: save data from two forms into one table

Quote:
Originally Posted by mike60smart View Post
Hi

From what I can see you have to study Table Normalisation.

Your Fee table should NOT have a field for each Month.

You would need a field named "MonthsID"

You would need a table which contains a list of all Months.

Then on your Form for Data Input you would have a Combob Box whose Record Source would be the values from your List of Months tables.

You are Linking FeeID - Autonumber to a field in your Batch table which does not have an Autonumber Field. Is BatchID a Number Data Type?
yes batchid has number datatype. currently i am interested in saving the record in another form. kindly guide the process to save data from these fields to another form. thanks
vagues0ul is offline   Reply With Quote
Old 10-29-2018, 09:11 AM   #9
mike60smart
Newly Registered User
 
mike60smart's Avatar
 
Join Date: Aug 2017
Location: Dunbar, Scotland
Posts: 439
Thanks: 21
Thanked 90 Times in 89 Posts
mike60smart will become famous soon enough
Re: save data from two forms into one table

Hi

Sorry but you need to get your tables constructed correctly BEFORE you start saving data.
mike60smart is online now   Reply With Quote
Old 10-29-2018, 01:02 PM   #10
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,792
Thanks: 57
Thanked 1,268 Times in 1,249 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: save data from two forms into one table

Not sure if it applies to this situation; but typically, one would use a form/subform setup to display and enter data for related tables.

Just my 2 cents...
theDBguy is online now   Reply With Quote
Old 11-04-2018, 02:19 AM   #11
soap
Newly Registered User
 
Join Date: Nov 2018
Posts: 25
Thanks: 4
Thanked 0 Times in 0 Posts
soap is on a distinguished road
Re: save data from two forms into one table

Any further solution to this request. I'm interested too. Thanks

soap is offline   Reply With Quote
Reply

Tags
store , table append , update

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple table data to save to a different table from a form steve1111 Tables 6 03-06-2014 09:21 AM
How to save data from different forms in different tablets Rahmonic Forms 9 03-12-2013 05:06 AM
How to save data to a second table? japi_s General 3 02-16-2007 07:13 AM
forms cannot save the data rahultiwari Forms 4 03-03-2005 06:42 PM
save form data to a table smitty27629 Modules & VBA 0 02-01-2005 05:53 PM




All times are GMT -8. The time now is 10:19 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World