Auto population

[Keiath]

Hi guys

Firstly I am a bit of a novice, so please bare with me and sorry if this question is a little lame....

I have a table that has account number, customer names and address, city and post codes (the source table)

Then a second table with same details plus other information I want to add to that record.

In a form created from the second table I want to type into the account number (or via drop down box) and then once selected to populate the remaining fields, (customer name, address city post code) in the manor I've point out (as I want to in future be able to search certain fields such as post code's)

I am sure this is 'simple' but I cant figure it out please help..

Thanks in advance

 

[pbaldy]

Like this?

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

 

[Keiath]

Like this?




I need to actually save the 'customer' details in the second table along with other information I need to add

The only way i can explain what I mean is imagine an accounting program and your creating an invoice, you would look up/type in the account number and it would fill in the customers details, that's what I am having problems with.

or to put it another way say you wanted details of a stock item to type in the stock code and once enter it would then auto populate the other fields 'description price ect'

Hope that makes sense

 

[GinaWhipp]

You would not need to save that information to a second table. All you would need to do is relate those tables together and then when you want to see it create a query. In a database you should never want to have the same information in two or more tables. Perhaps you should do a little reading...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page...
http://www.mvps.org/access/resources/index.html
A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html
MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials
Sample data models...
http://www.databasedev.co.uk/table-of-contents.html
http://www.databaseanswers.org/data_models/
Naming Conventions…
http://www.access-diva.com/d1.html
Other helpful tips…
http://www.access-diva.com/d11.html

 

[Keiath]

thanks noted on the information in two tables, but that doesnt really answer what i was asking about auto populating, I am guessing this is done in same way via a table query?

 

[pbaldy]

My link addressed saving the values at the bottom.