How to write in the code dashboard button , so that when I assign the column "Kategoria" in the table "BazaDanych" it automatically assigns me the article code that is column "Kodartykulu" from the table "daneflexsim" and if there are not enough article codes it prints "0"?
Hi @kryczka_17, was Felix Möhlmann's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.
If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.
You could use SQL to find all article numbers that belong to a category. If you do this for all possible categories, you can then loop through the "BazaDanych" table and assign entries based on the category. (Check which category the row belongs to and check if there are still entries for that category. If yes, assign the first available value and remove it from the available ones. If not, assign 0 instead.)
15 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
