Hi all, was hoping to get help with the following status issue.
I have a table called Take Off Groups, which relates to the view below.
Each of these records relates to two other tables; Material Take Offs and Order Details.
Take Offs that appear as 'Drawn Off', contain material that has been request by User Group A lets say, material requested here needs to be ordered by User Group B. I want to put a status in the Take Off Group table to say whether or not that material has been 'Ordered' or 'Received in Full'.
Example;
The above 'Overall Status' of this would be Received in full as all of the related order details are saying that.
I know this will probably require a lookup formula, but just don't know how to execute without errors because I'm looking up through a list of the Request Status'
I'm not sure if I fully understand your data structure clearly. First of all, what is the expression (LOOKUP) that's producing error?
User | Count |
---|---|
17 | |
12 | |
5 | |
5 | |
5 |