I have a truck Receiving Form where the user indicates which Division their receiving from.
The same form has a trailer dropdown box for the driver to select the trailer their unloading to.
When they add a trailer into the drop down box from the Receiving Form, I need the division on the receiving form to populate the division field of the new vehicle theyโre inputting so administrators know which division is inputting new trailers.
I tried this expression in the Initial Value of the Vehicles (Trailer Storage) table but it doesnโt recognize the receiving_id field as its from the Receiving table and generates an error.
IF(CONTEXT(View)=โScale Receiving Entryโ,[receiving_id].[Division],"")
Any ideas on how I can populate the field? Thanks so much!
Receiving Form
User | Count |
---|---|
15 | |
12 | |
9 | |
8 | |
4 |