View Single Post
Old 10-29-2018, 09:00 AM   #8
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

Originally Posted by mike60smart View Post

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