ClearCollect(colCompanySites, Filter(Sites, ParentAccount = varSelectedCompany.'Account Name'))
Sort(
Filter(
'4655 Accounts',
Active
),
'Account Name',
SortOrder.Ascending
)
Set(varSelectedCompany, cmbAccount.Selected)
ClearCollect(
colCompanySites,
Filter(
Sites,
ParentAccount = varSelectedCompany.'Account Name'
)
)
ClearCollect(
colCompanySites,
Filter(
Sites,
ParentAccount = cmbAccount.Selected.'Account Name'
)
)