Building a Query for a Report - Combobox

[Czeszyn]

Hello Everyone
I hope that I ask this the right way. I have a combobox that I use to combine the employees first name and id number. So when you pull down the list you can select the employee you want and it is saved in the form. Now I need to create a query so that I can create a report on each employee separately. The query will not let me get the Employee Frist Name/ID from that saved field. I thought that what is saves in that field, you can retrieve it in your queries or reports. I do hope someone understands what I am asking, first time using a forum. Thanks again for any help.

 

[Mihail]

I think that I understand what you ask but also I understand that you don't know how the DBs work.
So read this very very carefully:
Database Normalization and Table Structures - Microsoft Access / VBA

 

[Czeszyn]

Hi Mihail
First thank you for responding. I thought I did all that. Each of my areas have been broken down into their own tables. In the one form, I just used a combobox to combine the first name and id number. So are you saying that I can get that out of a combobox?

 

[Mihail]

OK. Maybe my English make a jock with me .
Here: Beginner Advice for a Family Database - Access World Forums
you will see a DB designed from scratch. I'm pretty sure that you will find useful ideas for you.