Forum Discussion
Solved
link columns
Hello everyone, I have an issue. I explain myself with an example. Ex: I sell burgers for the same price but some client do not want pickles for example. Let's say that I sold 100 burgers for j...
Is that how your current data is stored? What can you tell me about the related table? What does the desired result look like?
Hi Thomas897
There are different ways to go about your topic. For example you could have a certain table structure, which allows you to count how many ingredients you've used for each burger. The table structure could look something like this:
| Burger | Bun | pickle | Steak | Cheese |
| 1 | 1 | 0 | 1 | 1 |
| 2 | 1 | 1 | 1 | 0 |
| 3 | 1 | 1 | 1 | 1 |
| 4 | 1 | 0 | 1 | 0 |
| 5 | 1 | 1 | 1 | 1 |
Here I've used binary columns to determine what ingredients where used for each burger.
Does this make sense? I'll gladly elaborate.
Best,
Martin
Hi Anonymous,
I would like to show that when I click on my supplier (ex: Kraft for my cheese), how much of their product is used on my 100 burgers.
I have all these informations but I cannot find a way to connect it...
Best,
Thomas
