R
Roxanne
I have an access database for IT trouble tickets. I have a table for the
trouble tickets themselves and an additional table that lists all our
customers so that the techs can pick the customer via a drop down box in the
trouble ticket form I created. My boss has asked for a field that would
show status of the customer's maintenance contract with us and the expiration
period of that maintenance contract.
I have added a maintenance status and expiration period field to the
customer table. Is there a way for me to get the maintenance status and
expiration fields to pre-populate in the trouble ticket form when the tech
picks a certain customer. This way on every ticket opened, once the tech
picks a certain customer, their maintenance status and contract expiration
will automatically populate in the form.
Thanks,
Roxanne
trouble tickets themselves and an additional table that lists all our
customers so that the techs can pick the customer via a drop down box in the
trouble ticket form I created. My boss has asked for a field that would
show status of the customer's maintenance contract with us and the expiration
period of that maintenance contract.
I have added a maintenance status and expiration period field to the
customer table. Is there a way for me to get the maintenance status and
expiration fields to pre-populate in the trouble ticket form when the tech
picks a certain customer. This way on every ticket opened, once the tech
picks a certain customer, their maintenance status and contract expiration
will automatically populate in the form.
Thanks,
Roxanne