List of products with preserved value

Get Help Database
1

Hello people…

I need to separate a list of products every day that preserves the values, quantity from the order date.

I saw in the Food Truck template that for each product entered, a new record is created in a separate collection.

My question is… If I have 100 items every day will 100 records be created? Is this good practice?

Is there another way to store a list of products in a single record that is preserved so it doesn’t change?

Thanks

2

Hi Ewerton,

It is standard practice with any database driven app or website that you have a ‘join table’ which stores hundreds, thousands and often millions of records which represent a single ordered product. This is how it should be done and is best practice.

Cheers
Craig

1 Like
3

Thanks @crmorris2

thank you very much for your reply. I’ll follow up then.

Hugs from Brazil

1 Like