Creating new record from new data in a different table

**GordR** · 10-12-2012, 02:15 PM

Hi,

I have an access database that I use to manage my car dealership, part of it holds data of a stock vehicles, another aspect is invoicing.

As part of the invoicing form, I have a part exchange vehicle section which creates a new record in the part exchange table.

What I would like to be able to do is when a new vehicle is added to the part exchange vehicle table it automatically adds it to the main vehicle table so it shows as a stock vehicle.

Any advice?

Thanks
Gordon

**June7** · 10-12-2012, 03:08 PM

Why would a vehicle be in two tables? Are you duplicating vehicle information? That would be poor db design.

Creating new record from new data in a different table

Thread Tools

Creating new record from new data in a different table

Similar Threads

Using VBA to get data from a parent table record to a child table record (address)

DataMacro - Creating a record in a table based on 'FOR EACH RECORD' command.

From command button creating a record in another table

Creating unique record from record and field data

Creating new record in multiple Table through a form

Posting Permissions