I have two tables,
Order_ID and
Order_Dispatch
Order_ID contains the following fields,
1. Order_ID (Key)
2. Date_Time
3. AWB (Ref to Order_Dispatch)
Order_Dispatch contains the following fields,
1. AWB (Key Column)
2. Status
3. Date_Time
So, the workflow goes like this,
A user first enters Order_ID, Date_Time and scans AWB, and submits the form.
At the time of order dispatch,
A user will open Order_Dispatch, scans the AWB barcode in the AWB field, and submits the form.
Technically, post scanning AWB in Order_Dispatch, an inline view should pop up below the form that shows details of Order_ID but the view is missing.
Please note that Order_ID is also linked to another table "Order_Details". The "Order_Details" table has column "Order_ID" which is "Ref" to the "Order_ID" table. So, when a user adds Order_ID in the "Order_ID" table, Inline view of Order_Details pops up
Am I missing something here? Could anyone identify the problem and suggest a workaround?
Please post screenshots of the current configuration that isn't working as desired.
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |