How to design schema for an order form linked to catalog of items?

Ask the Community How do I?
,
1

I’m trying to make an order form where customers can specify quantities of items, and have each item show a price and image.

I feel like the price and image of each item should be stored in one table, and individual orders placed by customers in another. The problem is, I’m not sure how to set up the tables and configure links between fields to achieve this. I would like to be able to change the price of items without having to manually reload the schema.

Anyone know how to set up this configuration in Stacker? Suggestions on alternate ways to model the data that can be easily implemented would also be helpful.

2

Hi @gubijon,

Which data source are you using to connect to Stacker? You should be able to create a link between the tables either in your datasource or directly in Stacker itself.

There is some more information in the help documentation on creating links between tables.

Hope that helps, please let me know if you have any further questions.