hi, i have some data that i want to look up based on a combo box, but some how im not able to do this is there some code that i have to input or do i just put in the table source???? these are on the same table "Employees", wich brings me to my other question.... based on this records i want another table called "Projects" be displayed in a spred sheet based on the proyects that he has or where assigned to him
this is an examble
Employee |V| <---- Based on this combo box diplay everything
Employee Id | |
Name | |
phone | |
Supevisor Name | |
Supervisor Email | |
Okay so you have table that has only the employee names? then another table with: Employee Id , Name, phone, Supervisor Name, Supervisor Email. And yet another table with: Project Number, Project Name.
If I'm incorrect, just give us a list of the tables you're using and the their fields.
Okay you're going to needs a field that is the same in both tables. I just having Employee ID in both tables. Those two fields in the table need to be linked. I'll walk you through the rest once you get that up.
its a table for making the M:M part i don't know if that's relevant.... but thats the way that i have it setup if i put Employee_ID on the Project Table, and Project_ID in the Employees Table wont i just be making redundant data???
ok thanx for tip but what you stated before i infact had it allready the relationships i don't know if that whats you where refering to.... but you lost me in the quote, i have to do this in the query builder or in the form???? where is the ''show option" and where do i put the criteria??? in the form??
im such a putz.... sorry... "QUERY" now we are in the same page.... but no luck id what u told me and it said no value given, also if i uncheck it it wont let me select if i go to the wizard, i do it manually it gives me that error no given value....
thnx for all your help... and sorry to be pain but you lost me whe you said...
Originally Posted by dwil2g1
you need the form to be open to use the query. That's.
you mean running??
because when i do that it runs but it doesn't display anything
but when i go to use the wizard and look the query it doesn't even show the Employee_ID because of the un check.... if i leave it checked and put the criteria that you told me it also says the same no value given....
Hrm...this should work fine....now lemme think. What are you using as your rowsource for the combo box? If you're using the Employee ID field from the query it will no show, but if you're getting the rowsource from a different table or query than it should work fine. Otherwise I'd have to see the database.