General high level question. (Must have arisen before).
I have simple table for "Supplier Details".
The data is UniqueSupplierCode, Name, Address, Email etc.
I want a SINGLE form which will allow me to Add new suppliers and modify existing ones.
How can I prevent the user from amending the UniqueSupplierCode once it has been set up.
They can obviously amend the name and address details etc.
I do not want to use autonumbering.