Hope you can help….
I have two tables one which included all my users and asecond table which has a drop down using the names on the first table, and onany forms the drop down displays the names.
When I run any query using the information on the drop downI have to us the ID number eg 3 but if I put the name of the user eg “ash” itdoes not return any information.
So when I try and design a pivot chart the chart displaysthe user as 3 but I need it to show the name or have some type of key whichwill display both.
Please help this is my last job before the thing isfinished.