lacampeona
Registered User.
- Local time
- Today, 03:03
- Joined
- Dec 28, 2015
- Messages
- 392
Hello Experts
I need some ideas how to make something.
I have a tableA which constains field status and I have field ID and ItemID.
Field status can have three values. Field status can be empty (field contain no data, empty field), entered or approved.
Now my problem is how to check that the field status for specific ItemID contains entered or approved?
Example
I have to tell to the user if the all statuses for ItemID (example:A001, it could be any other ItemID) contains status approved then he can destroy the itemID A001.
( in my case ID is only: ID=4)
If the itemID A001 does not contain all the statuses approved (ID=, ID= 1, ID= 3),he must check his data. the status for user to be able to destroy the item must be approved.
I was trying to use dLookup but I didnt get what i what. I manage to get results for one field. hmmm?
Imagine...we have :
tableA
ID status ItemID
ID=1 A001
ID=2 entered A002
ID=3 entered A001
ID=4 approved A001
ID=5 approved A002
ID=6 A003
ID=7 A003
Thanks is advance
I need some ideas how to make something.
I have a tableA which constains field status and I have field ID and ItemID.
Field status can have three values. Field status can be empty (field contain no data, empty field), entered or approved.
Now my problem is how to check that the field status for specific ItemID contains entered or approved?
Example
I have to tell to the user if the all statuses for ItemID (example:A001, it could be any other ItemID) contains status approved then he can destroy the itemID A001.
( in my case ID is only: ID=4)
If the itemID A001 does not contain all the statuses approved (ID=, ID= 1, ID= 3),he must check his data. the status for user to be able to destroy the item must be approved.
I was trying to use dLookup but I didnt get what i what. I manage to get results for one field. hmmm?
Imagine...we have :
tableA
ID status ItemID
ID=1 A001
ID=2 entered A002
ID=3 entered A001
ID=4 approved A001
ID=5 approved A002
ID=6 A003
ID=7 A003
Thanks is advance