Originally Posted by mike60smart
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