I have 3 tables, a master BusinessPartners (BP) table, which is linked to addresses and contacts, so there can be multiple contacts and multiple addresses per business partner.
On the BP table I use filter formulas to list the associated addresses and contact records.
Then on the Addresses and contacts I use rowlinks to associate to the BP data.
Now, when I build a BP form, I want to show two lists, one with the list of associated Addresses and one with the list of associated contacts.
The BP form is an auto created form with an InputRow which takes the BP name
I added a column list for addresses and it appears to have created a header in a block who's source is $[InputRow]
and a data field who's source is something that I dont fully understand.
So part 1 of this question is what does this syntax mean?
The list control seems to reference this combination of objects
And thus provides a list of associated addresses.
So I'm a bit confused at how this mechanism works.
When I added my contacts list, the default action was to simply link to ALL contacts, rather than a list filtered by the $InputRow
So I worked out that if I create a block and a data cell and populate them as the address block and cell are populated then I can use the same reference here as in addresses and it shows me the filtered list, so that's great.
I also worked out that I can do it with a filtered source like this:
The filtered source makes sense, so part 2 of this query is, is there a recommended way of doing it and why would one method be better than another?
Finally, part 3 of this query is, are there (or could there be) any plans to allow us to type in standard SQL statements into sources?
Since it would be quite simple to add a simple select and where rather than try to learn a new and slightly strange syntax.