How to share the same data for multiple rows

[Sport_MACMUS]

Hi guys,

I’d like to create a purchase record app by appsheet, there are 5 columns in my app which is date, item, price, quality, and delivery fee.

e.g. I purchased a listing of food, apple, banana and orange and total delivery fee is $11. And my question is how should I record this delivery fee?

1. Apple 11, banana 0, orange 0 ?
2. Apple 11, banana 11, orange 11?(if i summary delivery fee that will be coming 33)
3. Apple 3.666, banana 3.666, orange 3.666…

Please give me a good suggestion

[Marc_Dillon · Accepted solution]

You could add a “parent” Table to hold any number of “child” records, that are all grouped together by a “delivery”. Then just store the $11 value in the parent record.

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

[Sport_MACMUS]

Thank you, bro.

I got it.