About EricDevy

EricDevy · 10-25-2022

Hi All, I need some urgent help with a Valid_If statement please.I have a Parent Table for Orders. And I have a Linked Child Table for Order_Items.The Parent Orders Table has a "Order_Status" Ref dropdown to select the Status of the Parent Order and ...

EricDevy · 10-30-2022

I do have a list of " Order Status Ref Dropdown". 

EricDevy · 10-26-2022

I Can Only Choose One Order Status on the Order when the related Order Item Status is "Packed - Complete".IF(COUNT([Related Order_Items][SU_Order_Item_Status])= COUNT(SELECT([Related Order_Items][SU_Order_Item_Status], [SU_Order_Item_Status]="Cancell...

EricDevy · 10-25-2022

Thanks I tried that but then there is only 1 Status available to choose from on the Parent (Orders) dropdown. I have reworded my original post to try and make more sense of what I need. See below.Hi All, I need some urgent help with a Valid_If statem...

EricDevy · 10-25-2022

@TeeSee1 Thank you for your input. Not sure what you mean.I have this Valid_If Statement at the moment, but no matter which status I choose I get an error.ISNOTBLANK(FILTER("Order_Items",AND([SO_Number]=[_THISROW].[SO_Number],[SU_Order_Item_Status]="...

EricDevy · 10-25-2022

@Suvrutt_Gurjar Thank you for your response.1. Yes both tables reference each other (Part Of).2. Both Column Types [Order Status] and [Order_Item_Status] Are REF Dropdowns.

My Stats

EricDevy's Bio

Badges EricDevy Earned

Recent Activity

Help Please with Valid_If Statement for checking status of linked Order Items of Main Order

Re: Help Please with Valid_If Statement for checking status of linked Order Items of Main Order

Re: Help Please with Valid_If Statement for checking status of linked Order Items of Main Order

Re: Help Please with Valid_If Statement for checking status of linked Order Items of Main Order

Re: Help Please with Valid_If Statement for checking status of linked Order Items of Main Order

Re: Help Please with Valid_If Statement for checking status of linked Order Items of Main Order