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? :):):)

One question: why?

This does not make sense.

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 ;-)