Using VBA to Post Records to Other Tables

[Johnkl]

Hello

I have the below problem

I want to update (or create) records to two tables from two other tables

To be more precise

I have 2 tables tblQuotesMaster and tblQuoteDetails and a form with a subform to store data.

I want to transfer the Current record(s) from the form and subform to tables
tblSales
tblSaleDetails.

Can any one point to the correct direction on how I will create the field where the tables tblSales and tblSaleDetails are connected??

Any help will be appreciated

Kind regards
John

 

[agehoops]

Slightly confused, do you want to just form a relationship between tblSales and tblSaleDetails, or actually transfer the data, or both?

For the transfering the data, either create an append query, or do it in SQL in vb

 

[Johnkl]

No I just want to post to the tables using vba

 

[agehoops]

Then you'll need either the INSERT or UPDATE command to generate an SQL string, depending on if you want to create a new record, or edit an existing one

 

[Pat Hartman]

If quotes and sales have the same columns, keep them in the same table. That way you won't need any code at all. The user simply chooses the option to turn a quote into a sale by changing the status field.