Auto Increment

[jpgus]

Hi

😀

I need to sync from a source db that has an auto increment field (called IDnum) into a READ only Target db.

I need the target to have the same IDnum as the source.

I tried setting the IDnum field type in target to auto increment but it increments on its own and can become out of sync with source DB

I do not need the target to be able to increment IDnum on its own.

I tried unchecking the auto-increment property in the IDnum field in target db but I get an field type is not the same type error on sync.

What is the right way to handle this?

Thanks.

Jason

[Author]

Posts