Auto fill a column based on a selection in another

[alexb1373]

Hi,

I'm fairly new to Microsoft Access, and have been teaching myself how to use it over the past couple of months.

In my database I have a table of customers and a table of orders (where many customers have more than one order, so the primary keys for each table are customerID and orderID).

In the orders table, the first columns are:

OrderID CustomerID Customer Forename Customer Surname

I need my table to auto fill in the customer forename and surname based on the selection of customerID (the names are saved in the customers table).

I already have a lot of data filled in, so am looking ideally for a way to fill these name columns without having to re-input all the data.

I'm sure there's an easy way to do this, but I can't find it!

Thanks,



Alex

[alansidman]

Alex, hopefully, this is something that will help.

http://www.baldyweb.com/Autofill.htm

[alcapps]

You can use combo box for customerid field
event after uupdate
set me.forename = me.cbocustomerid.column(1)
set me.surname = me.cbocustomerid.column(2)

set cbocustomerid data source select customerid, forename, surname from customer order by forename, surname
column count = 3
column default = 1
column widths = 0;1;1

hopemthis helps