Creating a Report and needing to Pull data from another table

[Appollobsg75]

Hello I created a database CAHS Hour Tracker, and i have a form for data entry, it has 3 combo boxes the first is Employee name, 2nd is function and 3rd is outputs. The first combobox is pulling from CustomerID table the 2nd and 3rd are pulling from OutputsT. When I pull the data onto the report for the Employee Name it only gives me the WorkID number, I was hoping to be able to pull in the names on the report so i can group or soft by name. Is there a way I can relate the field to the CustomerID_Employee name to the WorkID and only pull the names? I think that is happening when I try outputs as well.

[pbaldy]

I don't see a report, but the solution is to base it on a query that joins the different tables together on the appropriate field(s). That enables you to get the names.

[pbaldy]

By the way, the data types need to match. If the ID field in the customer table is autonumber then the employee field in the hours tables needs to be Long Integer.

[Appollobsg75]

Thank you for the suggestion. I do not have a report cause, I'm trying to figure out how to get the information I want on the report. I have tried but it only pulls over the numbers. I'm looking at what you have stated, and I tried to create the query using both the Customerid table and the HourtrackerT,. I went into both and your are correct my customer id table has an autonumber, but I can't change the type in the HourtrackerT table since I want it to show up as text not a number. So I tried to also create a relationship between a workdid and trackerid in a query when i added both tables but it still did not work. when i looked at the table in spreadsheet view it only shows the number for the employee name. I do apologize, I have a intermediate level of training with Access, i have done report before but this is a little different. Thanks for your help.

[pbaldy]

The data type needs to match what you're storing, which is the ID (and this is normal, we typically save ID's in this situation). Change that data type to Number/Long Integer and you should be able to join the tables and show the name on the report.

[Gicu]

Please have a look at the attached updated file, hopefully would give you a push on the right path .

Cheers,

[Appollobsg75]

Thanks Vlad and Paul, I understand what each of you are saying and it appears that I might have figured it out. Vlad in your changes that you made, when I run the query report the names and things are there, but you have multiple entries and some of the functions do not match their outputs. Do I need to create a table with function and outputs that match up before I can have them correspond correctly? When I try and setup the way you have it, i loose the functionality on my combo boxes. I put on m functionsT combo box me.cboOutputs=null and me.cboOutputs.requery, but when I select the function and then want to see only those that correspond I do not see them I see all the Outputs. I have even tried it the way you have it and still I only get all the outputs I do not get the outputs that are specific to the function. I think Im doing something wrong but can't find it.