Trouble With Queries

Mar 10, 2010 at 6:05 PM

Hi, 

I want to perform the following filtered lookup.  

Show all Computers from the Physical Asset Site where the employee name on the physical assets list  for a computer matches the owner name on the helpdesk list.  Below is the filtered lookup I just dont know how to write the query.  Please be as detailed as possible.  The helpdesk list just has the employees name that submitted a ticket.  Basically I want to attach an asset to the helpdesk ticket for the particular employee, we have all of our assests recording in the asset list.  

Right now I can get it to where it pulls up all of the computer names and manually pick the correct computer but it would be nice to only show the computer that the employee owns.  

 

 

Get Information from this site:

Physical Assets Get Information from: Assets In this column <select id="ctl00_PlaceHolderMain_ctl01_FilterLookupFieldSection_ctl00_listTargetColumn" name="ctl00$PlaceHolderMain$ctl01$FilterLookupFieldSection$ctl00$listTargetColumn"> <option value="30eba06c-4362-4a3a-97b9-9acde5b4a71f">BB Upgrade Eligibility</option> <option value="e7a6daef-7b91-4999-b187-a34f97ea802d">Category</option> <option value="77d70f79-92d8-4d57-b36e-81f3cf55c943">Computer Name</option> <option value="46b00cd2-bc51-45d8-87e1-68f1be35275f">Condition</option> <option value="c042a256-787d-4a6f-8a8a-cf6ab767f12d">Content Type</option> <option value="df9ce466-08c6-4b26-a7c0-9673b6cce8f8">Current Value</option> <option value="26db13cb-207a-4b84-af81-1fe515b16878">Date Acquired</option> <option value="27357b96-aecd-4ba2-b8c7-172028554d11">Description</option> <option value="1d22ea11-1e32-424e-89ab-9fedbadb6ce1">ID</option> <option value="fa564e0f-0c70-4ab9-b863-0177e6ddd247">Item</option> <option value="c3090967-6d55-4962-8df1-90beac323418">Location</option> <option value="34ba6d7c-2707-4bec-ad97-a43dd96e30ac">MAC Address</option> <option value="294ae284-f636-4566-90d7-95480b37781a">Manufacturer</option> <option value="14470a52-7fb6-48c1-87b2-23d30269fe87">Model</option> <option value="ebb85cf8-047c-4ba7-9fd6-01bfa5ef126d">Purchase Price</option> <option value="ccce9e29-d22d-4c5d-8e17-359d99156045">Retired Date</option> <option value="6a528739-fa44-440f-84b0-29b99b6523b0">Serial Number</option> <option value="81253606-fa21-48b4-b0f2-6e8151eb5e67">SIM ID</option> <option value="dce8262a-3ae9-45aa-aab4-83bd75fb738a">Version</option></select>