As I wrote in summary , want to enter Invoice and have stock entered!
I created tables like
1)Invoice
2)Supplier
3)Merchandise
As I have Invoice in my hand, would start
is supplier in database If yes have all information and contact on head like
invoice looks.
than enter invoice # with purchase date and total amount.
Now I want to start entering invoice details
Item #, Categories.. and individual price (calculated with Qty And Unit price)
And have my stock entered.
I am learning Coldfusion and try to fulfill this application but I need some
help if some one can give me some layout idea like
Start using session variables , query Like <cfquery name= getstock
datasource="xy">
Select Supplier.SupplierName, Supplier.Contact, Invoive.InvoiceNumber,
Invoice.InvoiceDate
From Supplier, Invoice
Whrer Supplier.SupplierID = Invoice.SupplierID
</Cfquery>
I need step by step general Idea.
Will u please inspire me to learn coldfusion?