Append current record on Form to another table

[lcboley]

I have a table lead_information and a table sold_jobs. I want to put a sold button on the form for lead_information. I want the sold button to append the current record to the sold_jobs table. The fields in each table are the same except for the sold_jobs table has fields that the lead_information table does not.

It would be nice to have it open the sold_jobs form after it appends the data.

Any help would be appreciated.

Thanks.

 

[MStef]

Hello Lcboley!
You don't need two tables with the same
data, In your example I should use a SUBFORM.

 

[lcboley]

The two tables dont have the same data. They have some of the same information. The sold jobs table has additional data that the lead information table does not.

I dont want the lead information cluttering up the sold jobs table.

 

[Mile-O]

Well you be deleting the record from the source table when you move it to the new table (recommended ) ?

 

[MStef]

Ok lcboley!
Look at "DemoSoldJobsA97.mdb"