Populate Form And Make Editable

[Rick5150]

I am setting up a database to create a work order for manufacturing leather jackets.

The form has a dropdown menu that allows me to select the standard sizes (i.e. 36, 38, 40, 42, etc.). I have used a query called SIZING that is attached to the SIZING table so that when I select a size, each field is automatically populated with the correct chest size, sleeve size, back length etc.



Is there a way to do this that will allow me to populate the fields based on the size, BUT allow me to change a few measurements for customers with custom measurements - without disrupting the original values in the SIZING table?

[pbaldy]

One way would be the second technique here, copying in the standard values:

BaldyWeb - Autofill