How can I join or sum two tables to feed a subtable?
I´m working with recipies and for the ingredients of recipie subtable I need to be able to select from the ingredients or from the intermediate products, but in the same subtable. Having two subtables isn´t usefull. So, what I´m trying to do is creat one table where I can have all of the registrys of the ingredients table and all of the registrys of the intermediate products also. Is it posible? If it is, how?
4 replies
-
Dear Sole,
That should be possible. How it has to look like, depends on your database structur and your datamodel.
I have already sent you an invitation to my calendly where you can make an appointment with me for a screensharing session, in order to have a look on it together.
Kind regards, Jörg
-
hello, did you have a solution? that interests me too.
-
No, I haven't. I use 2 subtables and it didn´t end in something very practical. If you happen to find out let me know please, becouse I have to look at this databese to reinvent it...
-
Ok.
Content aside
- 4 yrs agoLast active
- 4Replies
- 1658Views