I have a table with a list of 3 documents that I need to track as due/received. Once I get all 3 I'd like to populate 1 other field with "all received." However, not all 3 documents are necessarily required.
In my form, I have the following expression:
[DocumentsReceived]: IIf([InventoryListReceived]="Yes" And [DRPlan_TestReceived]="Yes" And [VendorContractReceived]="Yes","YES","No")
[DocumentsReceived] is the field I want to update (I need to be able to run reports based on having all these preliminary docs, so I really need that to populate in a field I can query against going forward).
I can't find an example of "where" in my expression to tell it to update that particular field.
Do I need 3 more fields, each telling the database if that document is needed and then increase the expression? Something like:
[DocumentsReceived]: IIf(([InventoryListRequired] = "Yes" AND [InventoryListReceived]="Yes") And ([DRPlan_TestRequired] = "Yes" AND [DRPlan_TestReceived]="Yes") And ([VendorContractRequired] = "Yes" AND [VendorContractReceived]="Yes"),"YES","No")
I think I'm doing more work than necessary, but I can't wrap my head around the logic.