Here is what happens at the User level...

 

When a User goes to create a new Container - the Container Type field automatically populates with a preselected default.

The User is able to change from that default (if they want to) at this Create New Container form.

 

The User can also go to Settings and change the Default for a New Container

 

So here is the problem:

 

The User has made New Containers using the original Default

Then later they change the Default at the Settings table

This then changes all the previous Containers with the original Container type to the new Container type

This action is not desired (even though, in cases, it could be desired - my preference is to not have this happen)

- - - - - - - - - -

 

Here is what's happening inside...

 

Table: Container Types
Here, is a list of container types. Users are able to create new container types

Container types are not Name field only. They have other attribute fields.

 

Table: Settings
Here, is a field for the User to select the New Container Type Default from the Container Types table

 

Table: Containers
Here, the User creates a New Container.

The field is auto-populated with the Container Type Default selected in the Settings table.

 

The User can click a switch to reveal a choice field where they can choose to use the Default or Other.

If they select Other, a field appears that allows them to choose a different Container from the Container Types table.

This new Container choice becomes the New Container type rather than the Default.

 

The problem is - as stated previuosly - that if the Default set on the Settings table is changed - all the previously created Containers will have their type changed to the new Default

 

I expect that the solution is simple, but I don't know what it is.

Perhaps someone can help me with this...