add new data record

[ajitvyas03]

Dear user /friend



As I am using access 2019, beginner of access. I have created form add record. my question is that my each entry has multiple value . for example i created field as following way

bill no. party name name of item qty.(bags) weight rate (20 per kg) amount buyer

1 xyz onion 15 700 kgs 145 5075 vyz ltd
chana 10 60 kgs 900 2780 cy ltd
makai 05 100 kgs 700 17000 chandan store

thus i want to this data to add in database. party name will be same for entry but buyer name and other item will be different.
can any body solve by vba code please

thanks in advance

[ranman256]

master form & subform

the master for will use the tOrder table , then use a combo box to select the tCustomerID (all customer detail in tCustomer table)
the subform will use tOrderDetail table,

in the subform , set the LINK properties to link on OrderID key.
then you can enter each item in the subform.

tCustomer tbl:
CustID
Name
Addr
etc

tOrders tbl:
OrderID
CustID
OrderDate
etc


tOrderDetail tbl:
OrderID
ItemNo
Qty
Amt
etc

read up on master form/subforms.

[orange]

Further to ranman's comments/advice, I recommend you research database design.
You will encounter things like:
-business rules
-normalization
-join types.

Welcome to the forum and good luck with your project.