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