Need help creating input form

[bps]

Cloning ID is an auto number generator, and I want to make the value for Catalog number be the same as Cloning ID. The reason I cannot condense it into only 1 field is because I'm building the database on existing Catalog numbers, and there cannot be overlaps.

I have modified the autonumber counter using an alter table query so it starts from a catalog number above the existing ones. However, I don't know how to make the cloning ID = Catalog number on the input form I have created.




I have tried setting After update values to equal both fields as the same and using default value inputs. I might be approaching this the wrong way, what is the correct way to do this?

Thanks!

[aytee111]

You can set it on the BeforeInsert event.

[davegri]

Why don't you just rename the [Cloning ID] as [Catalog Number] in the table design?