Access combo box-show name, not ID, in table?

I have read through some old posts relative to my question, but came away
three times as confused and intimidated. Here is a simple and common example
of the equivalent of what I want to do:

Let's say I have a Suppliers table and form, and a Products table and form.
On the Products form I want to create a combo box for the Supplier field that
will use the Supplier table as a source to look up data. I want the combo box
to show me a list of names (not ID#s), AND I want to store Supplier NAMES
(not ID#s) in the Products table. When I look at the table, I want that info
(Supplier NAME) to just be there, without having to fish through
subdataforms, separate queries, or reports.

Is there a REASONABLE way for a non-programmer to accomplish this?

I notice that the sample Northwinds database shows names (as opposed to IDs)
in tables routinely. I have carefully studied design, field properties, and
relationships until my eyes glazed over. But for the life of me I cannot
duplicate this.

Then there's the question of expressions vs. SQL statements. How do I tell
the difference? How do I know which I need? How do I learn to write either
one?

I am using Access (in Office) 2003--with an Idiot's Guide for Access 2000.
(That's where I started, but didn't get far. This time I mean it--but I'm
beginning to wonder if I'm crazy.)