Table “Projects” have an enumlist column “Installation Address”, that is ref to table “Addresses”.
This enumlist column “Installation Address” have suggested values (selection from table “Addresses”):
SELECT(Addresses[Address ID], [Company ID] = [Buyer ID])
This enumlist column “Installation Address” should have initial value (“the latest” address of the same selection in table “Addresses”):
MAXROW(“Addresses”, “_ROWNUMBER”, [Company ID] = [Buyer ID])
User may add a new item to the enumlist (by adding new address to the table “Addresses”).
All three are working perfectly fine, separately. But when active all together, weird thing happening:
- Suggested value works, 2. Initial Value is selected, 3. User may add a new address.
But if user adds new address, it don’t go into enumlist. After saving new address, App brings user back to table “Projects”, with old addresses in the enumlist, and the new address is not there. But if saved with an old addresses, the new address, that entered by user, is saved on the worksheet. So, it seems that enumlist just don’t want to add the new address, if all three features are working together. Any way to fix this?
I also tried to use Valid If instead of Suggested Value:
IN([_THIS], SELECT(Addresses[Address ID], [Company ID] = [Buyer ID]))
But in this case user can’t add new address. Maybe there’s a way to allow user new adds?