Autofilling fields in tables (inexperienced Access user!)

Bo_

New member
Local time
Today, 09:08
Joined
Sep 1, 2010
Messages
1
I am creating my first database for a friend (I have very limited experience with Access). I have created a table of contact details with their product system and supply requirments (size and type of product we source). I am now trying to create a second table for orders (dates, amounts etc).I am trying to link these two tables with names as the ID so we can search via their name and pull up their order requirments. Unfortunately some clients are known by forename only, surname, or business name (all of these are in different fields in the original table). I would like to create this second table so you can search for e.g. Smith and it automatically populates the forename with e.g Sam, and the address and product requirements from the first table. If there are two Smiths, then Sam or John are options to choose, and then when you do, it automaticaly populates the rest of the table (this then shows you that you have the correct person). Then the amount of the order can be placed in manually, and the dates etc. All done! This is probably very simple, but I cannot work it out! I have looked through the forum but couldn't see anything obvious, making me think it is really too simple to be a problem!! ahh well...we all have to start somewhere!

I have Access 2007 btw.

Many thanks,

Bo
 
Welcome to AWF!

I would recommend that you look at the Northwind database from Microsoft. It probably already does what you need.
 

Users who are viewing this thread

Back
Top Bottom