Hello Community,
I have the problem to solve and already have spent nights and days, but no solution…
I have 2 tables:
- VISITS - reports from each machine inspection done by a technicians. Key field is UNIQUE ID.
- REPAIR ORDERS - all rows from table VISITS in which, in a specific column is indicated that a machine needs to be fixed. UNIQUE ID is copied from VISITS.
Tables are related by a machine serial number.
The idea is:
- when a technician goes to another inspection, opens the VISITS and a new row, if he fix something - he can dropdown the field where’re selected all related to this serial number - orders from REPAIRS ORDERS table (enum list). To make it easy to mark a specific order from a dropdown (not by just UNIQUE ID which is 8 digits/ letters only) - I have concatenated UNIQUE ID and the description.
So, could happen that he mark 1, 2, or 3 orders in a 1 visit. As a consequence - I have an information which orders are just closed.
In a consequence of concatenating UNIQUE ID and order description (separated by e.x. comma) - this field isn’t easy to automatise, e.g. build on them any script to close the order.
Do you have any idea how to built a mechanism in order to:
- have a dropdown concatenating UNIQUE ID + description (as I have actually, easy to recognise and mark by a technician) but receiving only UNIQUE ID in the row as a record?
I’ll appreciate for any help.
Radosław
LinkedIn
Twitter
