Pulling a lookup table in the criteria for a query request

[danoldenkamp]

Hello I'm new the forum and fairly new to Access,

I am trying to create a Query that will look for a particular support ticket based on the employee's name.



I want a dialog input box to pop up when running this query with a drop down of the employees.

I have a table called tblSupportTickets with a lookup table field called: "Reported by" that pulls the employee list from a table called : tblEmployees field : "Employees"


I am assuming the way to do this is to add criteria to pull the lookup table off "Reported by" but I don't know the syntax to add to the criteria field in the query design:

[frmSupportTickets]![Reported by]

Any help would be greatly appreciated.

[Jester0001]

I want a dialog input box to pop up when running this query with a drop down of the employees.

You would have to create a form to Pop Up when another control event is triggered.

I have a table called tblSupportTickets with a lookup table field called: "Reported by" that pulls the employee list from a table called : tblEmployees field : "Employees"

I'd suggest not using a lookup field on a table. This will explain why:
http://access.mvps.org/access/lookupfields.htm

but I don't know the syntax to add to the criteria field in the query design:

I think you are asking how to set a parameter for the query. Read this:
http://office.microsoft.com/en-us/ac...001117077.aspx

But, the parameter query won't have a drop-down combo box that is populated with names from the employee list. For that, you would have to do what I said above: Create a new form with a combo box control, and the Pop Up property enabled.

[danoldenkamp]

Thanks for your input.

I went to :

http://office.microsoft.com/en-us/ac...010256398.aspx

and made a form with a drop down and linked the query request

[Forms]![frmviewbyemplyee].[employeeselect]

I assume it isn't working because the employeeselect is a lookup field.

I am not experienced with Access. How would I link that employee name field without a lookup field?
Is there a preferred alternative?

[danoldenkamp]

Best practice would dictate using a primary key to similiar data fields to link relationships together.

I guess I was just looking for an easy solution with the data I already had for a dropdown menu to add that data to the form.

ie: a supportticket form where I can select the employee from a dropdown list that is updated by the employee table. It seems ideal for a lookup table, but not if I want to use that field. There has to be another way to have this funcionality. I guess that is a question for a different thread.