updating two files, More details of my question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2000, and trying to use two table. In a form trying to find a record in one table, if it is exist then get the value and put values in the form fields to update the second table. If it is not exist then create record in table1 and update the table two also.....

I have 4 files.
File-1
Customer.CustomerID
Customer.CustomerName
Customer.Address
and so on....

File-2
Product.ProductID
Product.ProductName
Product.BuyPrice
Product.SalePrice
Product.SupplierID
File-3
Invoice.InvoiceID
Invoice.InvoiceNo
Invoice.InvoiceDate
Invoice.CustomerID
Invoice.SupplierID
File-4
InvoiceDetail.InvoiceDetailID
InvoiceDetail.ProductID
InvoiceDetail.Unit
InvoiceDetail.Package
InvoiceDetail.Qty
InvoiceDetail.BuyPrice
InvoiceDetail.SalePrice
InvoiceDetail.TotalBuyPrice
InvoiceDetail.TotalSalePrice

Here is the detail, What I am trying to do...
Open a form and get input for the Invoice Header File
Invoice.CustomerID .....this information will come from Customer File in ComboBox
Invoice.SupplierID........This information will come from Supplier File in ComboBox

In detail line Items
Getting input of
InvoiceDetail.ProductID ....This will come from Product file If found item then BuyPrice and SalePrice should fill automatic in InvoiceDetail.BuyPrice and InvoiceDetail.SalePrice, Editing in price should be available to make some changes in prices....
If ProductID is not exist then Create this item in Prodcut File then come back to complete the InvoiceDetail input...

I would like to create form to do this job...
I do not know I explain it very well or not....Please help me...

Rashid
 
Rashid said:
I am using Access 2000, and trying to use two table. In a form trying to find a record in one table, if it is exist then get the value and put values in the form fields to update the second table. If it is not exist then create record in table1 and update the table two also.....

I have 4 files.
File-1
Customer.CustomerID
Customer.CustomerName
Customer.Address
and so on....

File-2
Product.ProductID
Product.ProductName
Product.BuyPrice
Product.SalePrice
Product.SupplierID
File-3
Invoice.InvoiceID
Invoice.InvoiceNo
Invoice.InvoiceDate
Invoice.CustomerID
Invoice.SupplierID
File-4
InvoiceDetail.InvoiceDetailID
InvoiceDetail.ProductID
InvoiceDetail.Unit
InvoiceDetail.Package
InvoiceDetail.Qty
InvoiceDetail.BuyPrice
InvoiceDetail.SalePrice
InvoiceDetail.TotalBuyPrice
InvoiceDetail.TotalSalePrice

Here is the detail, What I am trying to do...
Open a form and get input for the Invoice Header File
Invoice.CustomerID .....this information will come from Customer File in ComboBox
Invoice.SupplierID........This information will come from Supplier File in ComboBox

In detail line Items
Getting input of
InvoiceDetail.ProductID ....This will come from Product file If found item then BuyPrice and SalePrice should fill automatic in InvoiceDetail.BuyPrice and InvoiceDetail.SalePrice, Editing in price should be available to make some changes in prices....
If ProductID is not exist then Create this item in Prodcut File then come back to complete the InvoiceDetail input...
Click to expand...


This kind of thing is normally dealt with by using the combo
box's NotInList event to upen the product form. Check Help,
there should be some example code.
 
Back
Top