JimbobGilb
Posts: 28
|
Posted: 12/07/2011, 1:29 AM |
|
I want to throw an error up when data is incorrect but I need to do an either or formulae but not sure the best way. The idea is as bellow. Each works on its own but cannot figure the or bit out.
If PickedItems.ShippedBy.Value = "Export"
then
If CCDLookup (Ucase("PartNumber"), "PendingPicking", "PartNumber="& DBConnection1.ToSQL(PickedItems.PartNumber.value, ccsText) & "AND EnteredBY<>"& DBConnection1.ToSQL(PickedItems.ShippedBy.value, ccsText),DBConnection1) <> Ucase(PickedItems.PartNumber.value) Then
PickedItems.Errors.addError("Part number not shipped.")
else
If CCDLookup (Ucase("PartNumber"), "PendingPicking", "PartNumber="& DBConnection1.ToSQL(PickedItems.PartNumber.value, ccsText),DBConnection1) <> Ucase(PickedItems.PartNumber.value) Then
PickedItems.Errors.addError("Part number not shipped.")
I am sure it is something simple but it has got the better of me at the minute.
I look forward to a response,
|
|
|
|