Hi,
I am fairly new to Access Databases but I am designing a Helpdesk/Job system for our IT department.
I have created a table to hold the information and then created a form for the user to complete with the job/issue details. Is this the most efficient way to do it?
One thing I would like to do is make the multiple choice selection change depending on the previous choice (see below)
The first column is 'Category' so the user selects Laptop/Mobile/Software etc
The 2nd column is 'issue category'. I want the choices to vary depending on the answer in the 'Category' column. (i.e. if they choose mobile phone I want the 'issue category to display mobile phone issues).
is this possible? any help is welcome.
Thanks