Hi,
I'm having a few issues with MS access 2010. And this is actually 2 questions.
I'm trying to link 2 fields of a table to 1 field in another table.
In a incident management system. 2 fields consist of Service Type and Priority which in my design should update automatically if i select a certain Service type, for instance a server downage. it should then automatically fill in the corresponding priority(in this case high).
I've mostly given up on the design I stated earlier. And linked the two fields of my other table to a single field in the other using a drop down box method. the only problem now is(and i will include a picture) is that both fields that need to be shown in the field are visible in the drop-down-box but when i select one of the options it merely shows the first field.
I sincerely hope that one of you can help me solve this issue since its for the project I need to finish my internship.
Yours truly,
Ikkileo
I'm having a few issues with MS access 2010. And this is actually 2 questions.
I'm trying to link 2 fields of a table to 1 field in another table.
In a incident management system. 2 fields consist of Service Type and Priority which in my design should update automatically if i select a certain Service type, for instance a server downage. it should then automatically fill in the corresponding priority(in this case high).
I've mostly given up on the design I stated earlier. And linked the two fields of my other table to a single field in the other using a drop down box method. the only problem now is(and i will include a picture) is that both fields that need to be shown in the field are visible in the drop-down-box but when i select one of the options it merely shows the first field.
I sincerely hope that one of you can help me solve this issue since its for the project I need to finish my internship.
Yours truly,
Ikkileo
Attachments
-
105.9 KB Views: 47