× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

Intermediate tables?

3 Jahre 9 Monate her #9756 von R
Intermediate tables? wurde erstellt von R
Hi,

Can CC create intermediate tables so that the cascading effect of changes does not come through?

Classic example.

You sell your product which is an Orange at £0.75 per unit this week.
Next Orange increases to £0.80 per unit.
I want my order to retain the £0.75.
So this would normally require an Intermediate table to preserve the data at that point in time?

Many thanks in advance

R

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

3 Jahre 9 Monate her #9764 von Carl Fuentes
Carl Fuentes antwortete auf Intermediate tables?
CC is not supporting this feature at the moment.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

3 Jahre 9 Monate her #9765 von Søren Beck Jensen
Søren Beck Jensen antwortete auf Intermediate tables?
This also sounds like the wrong solution for me. At least for the example provided. Instead simply add a "price" field to your orders table and store the actual price with the order when it is created. No need for any extra tables.

Søren Beck Jensen
Founder, Component-Creator.com

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

3 Jahre 9 Monate her #9768 von R
R antwortete auf Intermediate tables?
That is fine if that is your setup.

My requirement is not a sales order setup.. but that is the best way to describe as you have many sales lines per sales order.. each sales line can have many products either per sales line or several per sales line etc...

Thanks for replying so I know I need to do my own dev here.

Thanks

R

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

3 Jahre 9 Monate her #9770 von Søren Beck Jensen
Søren Beck Jensen antwortete auf Intermediate tables?
Yeah, that does sound like it needs some custom development.

Søren Beck Jensen
Founder, Component-Creator.com

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Ladezeit der Seite: 0.180 Sekunden
Powered by Kunena Forum

Wir verwenden eigene Cookies und Cookies von Drittanbietern, um Ihr Nutzererlebnis zu verbessern und Ihnen einen optimalen Service zu bieten. Wenn Sie die Website weiter nutzen, gehen wir davon aus, dass Sie mit unserer Cookie-Politik einverstanden sind.