How to copy records from other Table and update current form's Tab

I

Irshad Alam

Not Always, But maximum time, all the materials of the store is been
delivered on DeliveryNote. So we prepare a Delivery note whose fields are as
follows :

DeliverTabA - Table Name, based on this table Delivery Form is made
DoNo (Numeric & a primary key)
DoDate
Customer
Remarks

DeliverTabB - Table Name , based on this table delvery Subform is made
DoNo (Numeric and has relationship with DeliverTabA)
ItemNo
PartNo
Desc
Qty
UPrice
ExtPrice



Now when the invoice is made there is field where DoNo is feeded. I want
that When the DoNo is feeded and after update of this field, its should
populate the subform fields of Invoice as the fields are same. Its not always
that the invoices is based on Delivery Note, sometime it is required. This is
the reson I dont make the relationship inbetween these Delivery note table
and invoice table. I want to keep both seprate But would like to get the Data
of delivery note when required .
The Fields of Invoice are :

InvoiceTabA (Table name, Invoice Form is based on this table)
InvNo (numeric and primay key)
InvDate
Customer
DeliveryNo (this is field, that after update i want fill the subform )
Remarks


InvoiceTabB - (Table Name ,Invoice subform is based on this Table)
InvNo (numeric key, relationship is based on this field)
ItemNo
PartNo
Desc
Qty
UPrice
ExtPrice



Could any of the professional can advise me, what steps I should use to save
my hudge time to enter the same data on the Invoice Form which is already in
the Delivery Note form. I can ask user to copy and paste as it will be unsafe
that if they make mistake then complete inventory system will be effected.

Please advise.
 
Top