Terry, you already have a Customers table (the row source for the combo
box). Presumably you are now talking about using that information in another
tables (such as orders for customers).
Open the Northwind sample database (installed with Access).
From the Tools menu, choose Relationships.
Notice how the Orders table has a CustomerID field, related back to the
Customers table.
Now Open the Orders form in design view.
Right-click the CustomerID combo box, and choose Properties.
On the Format tab, Column Count is 2, and Columns Widths is 0";2".
As a result the combo stores the CustomerID (the Bound Column property is
1), but displays the CustomerName.
You will also see how the customer names appear on the form. These fields
are not part of the Orders record. The RecordSource for the form is a query
that reads these from the Customers table. If a customer changes address,
you only have to do that once in the Customers table, and all the orders
automatically show the new address.
That is probably all you need, but in the case of Northwind they wanted to
allow for sending an order to a different address. As a result, they *do*
store the shipping address. If you look at the AfterUpdate event of the
CustomerID combo, you will see how they copy the current customer's address
into the "Ship To" address fields. If you really need to do that, you can
copy their approach.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Terry" <ve****@hotmail.com> wrote in message
news:Qn*******************@nnrp1.uunet.ca...
There is probably a real easy answer to this one. Using access 2000, I
have a database with about 1000 client records in it. I am using a combo box in
a form which when I click in it, all of the client names are listed and
selectable, which is exactly what I want. When I click on a client name,
their name goes in the box, but the remaining client information doesn't
change, which of course has the potential in corrupting the entire
database. I want to be able to select a client name, and have the remaining
information for that client fill in automatically in the form. Any
suggestion on how to resolve this would be appreciated. Thanks in advance.
--
Terry