Problem displaying information in Label wizard

[BillD]

I am trying to use the label wizard to make ID cards with Avery templates. I
created a query from two tables. The first table is for first and last name
using text boxes. The second table is for getting work assignment, staff
position, work area these use combo boxes. When ran the query all of the
information showed up as it should with all the information in the combo
boxes corresponding to the information from the text boxes (first and last
name). When I created a report again all of the information was displayed
correctly.
The problem I have incounterd is when I create the label wizard the first
and last name show up, but the other 4 items only display a number the
primary key number (auto number) for the items I selected.
Could someone please advise me on how I can get the information I need to
appear in the label other than the record number.
I am still kind of new to Access (this is my first big project) so if you
could please explain it in simple terms that would be great.
Thanks

 

[Duane Hookom]

It sounds like you have used lookup fields :-(
http://www.mvps.org/access/lookupfields.htm

If you want to display text values, you should include the tables/fields
containing those text values in your report's record source.

 

[BillD]

I am not sure I totally understand what you are saying. I know the fields for
the first and last names are fields that I enter in a form and those show up
fine on the ID badge. The other fields in my Assignment table are lookup
fields in the table and form that get information from another table. Are you
saying just include the lookup tables in my query and add those fields to the
bottom section of the query. If this is correct the problem I have is those
tables when added to the query cause the query not to run I think due to the
join properties.

Any advice you can give will be greatly appreciated. As I said I am at a
novice level so if you could explain in simple terms it would be great. I
have had good success with the data base to this point everything in it is
working perfect except for this.

Thanks again for all your help

 

[Duane Hookom]

"Are you saying just include the lookup tables in my query and add those
fields to the bottom section of the query." Yes. If you can't figure this
out, provide your table structures, SQL view, and what happens when you run
the query.

 

[BillD]

I got the problem solved. I added the lookup tables and then had to change
the join properties for all three. I changed the properties to #3 and when I
ran the query it worked fine. Then when I opened the label that I was having
trouble with I deleted the text box fields and did a drag and drop from the
available field list. This time instead of four text boxes I got 4 combo
boxes. When I viewed the label in print view all of the information was there
in the correct order without the numbers I was getting.

I want to thank you for all of your help. It was a simple fix that I was
hung up on and you led me in the right direction. I appreciate what you were
able to do for me it was also another good learning experience.

 

[Duane Hookom]

I wouldn't expect you would get combo boxes if you dropped the appropriate
fields from the added tables.

 

[BillD]

I don't know if that is normal, but I did look at some of my forms and in
design view they show a combo box (with the little down arrow in the right
corner) but in print view it is like a standard text box with all the correct
information. The same with the lable wizard in design view it is a combo box
and in print view it is just a text box with the correct information from the
tables.
So it may not be the exact way it should be but it works so I am going to
run with it rather than take the chance of messing things up. In the future I
will use your recommendations as I have printed out all of your responses. I
will be working on another data base soon and will have time to follow all
the steps you have outlined.

Thanks again for all your help