Furthering this example, if Accounts is fed to a Gallery control, use the formula to reference the SLA for the selected account. The reference can't pass through a function, a variable, or a control. For example, if the data source is Accounts and the lookup is SLA, the column reference would be Accounts.SLA. Provide the formula as if you were referencing the column directly.Ĭolumn references must be direct to the data source. If this limitation poses a problem in your app, add the foreign table as a data source, and use it directly.Ĭhoices doesn't require column names to be strings and enclosed in double quotes, unlike the ShowColumns, Search, and other table functions. Choices returns all columns of the foreign table.īecause Choices returns a table, you can use Filter, Sort, AddColumns, and all the other table-manipulation functions to filter, sort, and shape the table.Īt this time, you can't delegate Choices. By using Choices, you eliminate the need to add the foreign table as an additional data source. This function is commonly used with the Combo box control in edit forms.įor a lookup, the table that Choices returns matches the foreign table that's associated with the lookup. Use the Choices function to provide a list of choices for your user to select from. The Choices function returns a table of the possible values for a lookup column. Returns a table of the possible values for a lookup column.
0 Comments
Leave a Reply. |