I have need a simple invoice form

meenctg

Learn24bd
Local time
Today, 18:14
Joined
May 8, 2012
Messages
133
Idea:
I have need a simple invoice DB
Tables: Order> orderNo,CustName.
product > productName,Price (here will stay product with price)

I have a form where i can entry many products with a orderNo and Name

(If here need Subform but i'm not clear about create subform)

I wanna every Order table record (orderNo and CustName ) will contain many products records.Where Product table will share the product list.

When i print a report by OrderNo it will be like
attachment.php


Will any body help me please?
 

Attachments

  • invoice.png
    invoice.png
    24.2 KB · Views: 1,822
You will need two tables for this. The table structure I would use would look something like;

TBL_InvoiceHdr
InvID (PK)
InvNum
InvDate
ClientID (FK)

TBL_InvoiceDtl
LineID (PK)
InvID (FK)
ItemID (FK)
Qty

You will also need tables to store Client Details and Item Details (description, price, etc.)

You will need a Main Form bound to table TBL_InvoiceHdr then a Subform bound to table TBL_InvoiceDtl the Parent/Child relationship between these tables will be maintained through the field InvID which is the primary key (PK) of
TBL_InvoiceHdr and foreign key (FK) of TBL_InvoiceDtl
 
will you give me tamplate or video tutorial?
 

Users who are viewing this thread

Back
Top Bottom