CustomerID drop-down & DB table holding companies?

Dear all Overview: I have just downloaded the latest version of OTRS for Windows to evaluate for a small IT-Service Helpdesk dealing with external customers. I am using the default OTRS database as a backend and do not wish to auto-populate. I'm new to OTRS - go easy with me! BTW, OTRS has a very nice look and feel about it - compliments to the developers! Background: Our customers are companies and support requests come from persons (contacts). There can of course be multiple persons in a company requesting support. From what I've read (mailing lists & admin manual) I believe the OTRS way of grouping persons by company is by using the same CustomerID. Problem: So that my agents can't make any mistakes, is it possible to turn this field into a drop-down list with pre-defined values (company1, company2, company3 etc.)? It would also be nice if agents could add new companies to this drop-down if they didn't exist with a "New Company..." option. Finally, if a particular company is selected, would also be nice if another field (free text?) displayed the persons (contacts) within the company. If these persons don't exist, then a "New contact..." option. Solution?: I think what I need are database tables holding all my companies and their contacts - which I could add to via OTRS. Am I on the right track? I have absolutely no idea how I would do this? Not sure which code to change and where. Also not sure how to add new tables to the DB. I would really appreciate your comments for a complete beginner! Many thanks in advance. Regards Oliver

Dear all Is it possible to 'hook in' another mysql db to auto populate values such as CustomerID? We currently have an accountancy program running on another mysql 4.0.20a db. All customers (companies) and contacts (individuals) are already input here. Would be great if OTRS could use this info. Any ideas how and what I need to change/configure? I would really appreciate your comments for a complete beginner! Many thanks in advance. Regards Oliver
participants (1)
-
Oliver Buckie