I have a default reference table with prices for different types of fruit - e.g. pear 1 $1.05, pear 2 $3.02, pear 3 $2.01, apple 1 $7.56, apple 2 $15.02.... and so on ... the list is ~200,000 rows long. I also have a summary table, which has different baskets price arrangements based on the reference table - e.g. basket 1 price=pear 1 + apple 5 + plum 11; basket 2 price = pear 5 + apple 7 + grapes 3; etc. What would be a good way to construct a tool which would allow DIFFERENT users to calculate basket prices using different fruit prices? E.g. User 1 wants to calculate the price for basket 1 by changing the price of pear 1; User 2 wants to calculate the price for basket 1 by changing the price of apple 5? I know I can copy through a triggered action the different basket component prices from the reference table to the summary table, though I need the reference table to stay unchanged, and I can't copy 200k rows every time a user updates a price. Any suggestions about a structure?
Thanks!
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
VA123
I have a default reference table with prices for different types of fruit - e.g. pear 1 $1.05, pear 2 $3.02, pear 3 $2.01, apple 1 $7.56, apple 2 $15.02.... and so on ... the list is ~200,000 rows long. I also have a summary table, which has different baskets price arrangements based on the reference table - e.g. basket 1 price=pear 1 + apple 5 + plum 11; basket 2 price = pear 5 + apple 7 + grapes 3; etc. What would be a good way to construct a tool which would allow DIFFERENT users to calculate basket prices using different fruit prices? E.g. User 1 wants to calculate the price for basket 1 by changing the price of pear 1; User 2 wants to calculate the price for basket 1 by changing the price of apple 5? I know I can copy through a triggered action the different basket component prices from the reference table to the summary table, though I need the reference table to stay unchanged, and I can't copy 200k rows every time a user updates a price. Any suggestions about a structure?
Thanks!
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.