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!
Add Trailer (Vehicle) Form
Add Vehicle Form