I'm creating a database to help automate generation and tracking of ticket numbers for a help desk database.
I have three tables:
* Ticket table (ticket_ID = PK)
* Applications table (App_ID = PK)
* Vendor table (Vendor_ID = PK)
My primary keys are Autonumbers, and, the Vendor table is a lookup table for the Applications table, which in turn, is a lookup table for the Ticket table.
Ticket (M:1) Application
Application (M:1) Vendor
A ticket comes in, the Help Desk Associate generates a new ticket number, and clicks the combo box to find the referring application.
The combo box is setup with two columns (App_ID & App_Name, respectively). App_ID is the bound column, of course, and hidden from view so not to confuse the Help Desk Associate with "undefined numbers" by making the column width 0". I cannot set "Limit to List" to NO because of this factor.
Here are my questions:
#1) If the Application is not listed in the combo box, how can I setup the combo box to accept a new entry into the Application lookup table?
#2) Can I do this WITHOUT referring to another form for sake of simplicity, having all the referring Application fields listed on the Ticket Form; so that if a NEW entry is typed into the combo box, the fields referring to the application CLEAR so that the new entry can take place?
How can I do this with the combo box setup with the Bound Column 0"? Remember, Limit to List is set to YES because of this and cannot be changed.
I have the relationship Application:Vendor setup the same way, as the person entering in a NEW APPLICATION will of course have the possibility of entering in a NEW VENDOR.
THANK YOU IN ADVANCE! ANY SUGGESTION IS APPRECIATED!
Jim Meyer
NMCI Information Strike Force
EDS, Inc.
I have three tables:
* Ticket table (ticket_ID = PK)
* Applications table (App_ID = PK)
* Vendor table (Vendor_ID = PK)
My primary keys are Autonumbers, and, the Vendor table is a lookup table for the Applications table, which in turn, is a lookup table for the Ticket table.
Ticket (M:1) Application
Application (M:1) Vendor
A ticket comes in, the Help Desk Associate generates a new ticket number, and clicks the combo box to find the referring application.
The combo box is setup with two columns (App_ID & App_Name, respectively). App_ID is the bound column, of course, and hidden from view so not to confuse the Help Desk Associate with "undefined numbers" by making the column width 0". I cannot set "Limit to List" to NO because of this factor.
Here are my questions:
#1) If the Application is not listed in the combo box, how can I setup the combo box to accept a new entry into the Application lookup table?
#2) Can I do this WITHOUT referring to another form for sake of simplicity, having all the referring Application fields listed on the Ticket Form; so that if a NEW entry is typed into the combo box, the fields referring to the application CLEAR so that the new entry can take place?
How can I do this with the combo box setup with the Bound Column 0"? Remember, Limit to List is set to YES because of this and cannot be changed.
I have the relationship Application:Vendor setup the same way, as the person entering in a NEW APPLICATION will of course have the possibility of entering in a NEW VENDOR.
THANK YOU IN ADVANCE! ANY SUGGESTION IS APPRECIATED!
Jim Meyer
NMCI Information Strike Force
EDS, Inc.