Update table 1 when data is entered into table 2 (1 Viewer)

[veraloopy]

Hi

I know there is something about this on here already but I've been searching all day and can't seem to find it.

I have 2 tables (tblVehicle and tblBuild) both with a field called "BuildNo" which have a one-to-many relationship set to 'Cascade update', etc

Users only input the data into tblVehicle but when they do, I need access to automatically create a new record in tblBuild using the same "BuildNo" number from tblVehicle.

Any ideas?

 

[georgedwilkinson]

One question: why?

This does not make sense.

 

[veraloopy]

George you are quite right, I've been away for the weekend and come back to work wondering what I was thinking!

All sorted now ;-)