newbie form question

[Boze]

I have 2 tables

*tblItem (below is partial list of what it contains)
ItemID (pk)
ItemNum
ItemDescrip
GroupID (1 to many with tblGroup. An item may be part of more than one
Group)

*tblGroup
GroupID (pk)
GroupName

I used the form wizard to make form based on tblItem. I selected ALL the
items in the table to appear on the form.
My question; How do I get my form to show the Group NAME from tblGroup? At
this time, since the tables are linked via GroupID, what I see in the form
is the Group ID number. Makes sense but I don't know how to hide the ID and
show only the NAME

Thanks in advance for any help

Boze

 

[Klatuu]

The easiest way would be to create a query that would include both tables and
base your form on the query rather than the tables.

 

[Boze]

Rick, that worked perfectly! Thanks for such a clear, step-by-step,
explanation. Very easy to follow and I think I even follow the logic of the
method you used. What a bonus

Really appreciate the help.
Boze

 

[Boze]

Thanks Katuu. I'm new enough to Access that I haven't looked into queries
yet. Guess it's time to start. I'll use Ricks combo box solution for this
project but I can see knowing more about queries is probably essential.

Apprciate the suggestion
Boze