database table 1 have field like, id,cnm,mn,addr,amnt,disc.
Now form1 insert their data in table 1 (cnm.mn,addr)
and when form 2 inserted their data in table 1(amnt,disc), that time that data will added within form 1 entry data in ms access.
so when form1 insert data in table 1 database, like id =1, cnm=abc, mn=123,addr=xyz,amnt=,disc=.
amnt and disc value inserted after form 2 data insert in table 1 then.
like id =1, cnm=abc, mn=123,addr=xyz,amnt=1000,disc=100.
What I have tried:
I have trying to Insert two forms of data in one table of MS Access Database. If any one known the Queries of it then please help me.
Suppose form 1 have customer_name,Mobile,Address and form 2 have Amount,Discount of the customer which name is added in form 1.
database table 1 have field like, id,cnm,mn,addr,amnt,disc.
Now form1 insert their data in table 1 (cnm.mn,addr)
and when form 2 inserted their data in table 1(amnt,disc), that time that data will added within form 1 entry data in ms access.
so when form1 insert data in table 1 database, like id =1, cnm=abc, mn=123,addr=xyz,amnt=,disc=.
amnt and disc value inserted after form 2 data insert in table 1 then.
like id =1, cnm=abc, mn=123,addr=xyz,amnt=1000,disc=100.