Hello,
i had a special request, i need to fill a form with data from 2 differents tables, with the use of SourceExpr propoerty in the form this should not be possible i think, is there any way to do it ?
thank you in advance
Your second table would have to be defined as a global variable and you would have to use that variable.field as your SourceExpr
but then we will use just one source table !
Yes, a form can only have one source table. It’s not an option to have two. I’m assuming the two tables are linked somehow, so there are plenty of options. I mentioned one, you could also add FlowFields to one of the tables that lookup the data in the other.
There is no getting around the one source table per form, though.
Why does this matter?
You are too focused on the code. Focus on the business need, describe what you need to do in your business and solve the business need, Don’t just write code.