G
Guernsey Gaz
Hi everyone,
I have a form called Job Card which has a combibox on it that looks up
serial numbers, when I use the drop down and select a serial number the
customer/owner and all the details appear in thier relevant boxes, so as you
may ask whats wrong?
If a customer/user has more than 1 machine and I choose a different serial
number it returns to the first serial number for that customer.
example: take machine serial number A11111 and select from the drop down,
the owner (Customer Gary) appears in another text box.
Machine A22222 belongs to Customer Bob, still no problems, but machine
A33333 belongs to Customer Gary and when I select A33333 from the drop down
Customer Gary appears in the text box but the drop down goes back to A11111.
I need the correct serial number to remain in the drop down as it relates to
the service record for that machine. I've got problems with that as well but
I'll leave that oner till later.
Any help would be gratefull, and I can send you the whole database and what
it is supposed to do if needed.
I have a form called Job Card which has a combibox on it that looks up
serial numbers, when I use the drop down and select a serial number the
customer/owner and all the details appear in thier relevant boxes, so as you
may ask whats wrong?
If a customer/user has more than 1 machine and I choose a different serial
number it returns to the first serial number for that customer.
example: take machine serial number A11111 and select from the drop down,
the owner (Customer Gary) appears in another text box.
Machine A22222 belongs to Customer Bob, still no problems, but machine
A33333 belongs to Customer Gary and when I select A33333 from the drop down
Customer Gary appears in the text box but the drop down goes back to A11111.
I need the correct serial number to remain in the drop down as it relates to
the service record for that machine. I've got problems with that as well but
I'll leave that oner till later.
Any help would be gratefull, and I can send you the whole database and what
it is supposed to do if needed.