How to add Single Bill No , Many products

Consider Bill Number as Main table and products are child table

Parent table : Bill Number

Child table : Products

Anyone Please Share Code For Single Inv No Maintaine Many products

I think you are building billing application, for this you need full accounting architecture with tables like

Inventory

Sales

Purchase

Sales Return/Purchase Return

P/L and Balance Sheets etc

In your specific question, you can have columns like

ID

InvoiceNo (Bill No)

Product ID,

Rate

Qty

Discount

GST

Amount etc

Nothing to take pain when inserting in one bill no. simply insert all the fields based on single invoice no

Ex: Bill No.1

Products:

1. Pen

2. Note

3. pencil

These All product Store in Bill Number 1

Hey

Elaborate your question or issue properly