How do I combine two fields into one field

[Bob Loder]

In my main table (tblWorkInProgress), I want one field "Adjuster" to be a
dropdown box whose source is a combination of the two fields "FirstName" and
"LastName" from a table (tblInsAdjusters). Also, I would like them to
appear in the dropdown list sorted by LastName.

Not as important but, what would be even "cooler", in the opened dropdown
the "combined name" appears as "Loder, Bob" (easier to sort by last name - I
think), but when chosen, it would show as "Bob Loder" in the field.

I have no idea how to write code, but I certainly know how to copy code!
:- ) Seems to me that I need to add a field to tblInsAdjusters like
"CombinedName" with a formula that effectively says, "FirstName" +
"LastName" or "LastName" + ", " + "FirstName". Or is it a query I need? Or
is it a similar "equation" in a new field in tblWorkInProgress?

I offer the last to demonstrate both my current level of knowledge (or lack
thereof), and that I have given the topic some thought before asking for
advice.

Running Access 2000 on Windows XP Pro. Split Db shared locally only on 6
computers. BE on SAN in peer-to-peer network.

Thanks in advance,
Bob Loder
Tampa, FL

 

[Bob in Tampa]

Thanks a million!
Not in the least bit confusing.
What a great newsgroup.

Bob Loder
Tampa, FL