I have need a simple invoice form

meenctg

meenctg

Learn24bd
Local time
Today, 08:35
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?
 
You must log in or register to reply here.

Similar threads

H
Solved Dlookup Or SetValue not working
Replies
17
Views
726
mike60smart
mike60smart
J
Create a form with dynamic number of tab?
Replies
6
Views
331
MajP
MajP
S
Need a Form With sub form with populated client info and a subform with services and price in items invoice, please help
Replies
3
Views
274
Pat Hartman
P
E
DLookup Function Alternative
Replies
19
Views
702
cheekybuddha
cheekybuddha
C
Subform Footer Textbox wont update
Replies
11
Views
446
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom