For some reason, what I select in the choice component does not match the input in the data table.
These are the options to choose from. A number from 1 to 5
Based on the Week number selection table
Does anyone have an idea how I end up with these numbers in the table?
That works!
Thank you! I understood it to be better practice to use the rowID in a selection table so that should I need to change the options, the rowID remains constant.
Well, yes. That is a good general rule of thumb.
But if you did that you would then need to add two extra columns.
First, a single relation column that matches the RowID value with the same value in the Week Number table, and then a lookup column to fetch the Week Number value.
But in this case where you are dealing with a short list of numbers that will probably never change, I’d argue that’s a bit of overkill.
Great point! Much appreciated.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
