By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,221 Members | 1,106 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,221 IT Pros & Developers. It's quick & easy.

auto populate

P: n/a
Hi,

I'm still struggling with my tables - frustrating.

If a field in table one is completed I want the following field to auto
populate (dependng on the answer to the first field). I have created a
seperate table with the data to auto populate from but I don't have a
clue.

If you could answer with baby language i'd appreciate it! Or e-mail
ke*********@diageo.com for more complex info.

I hate this to look like i'm using everybody here to build my database
but i've tried looking everywhere - i can't understand most of it even
though i've read and access book!

Sorry, and thanks

Nov 30 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
keri wrote:
If a field in table one is completed I want the following field to auto
populate (dependng on the answer to the first field).
No, You don't.
I have created a
seperate table with the data to auto populate from but I don't have a
clue.
When you need to see or use this data you will establish a relationship
between the two tables and you will gather the data together with a
query.

Nov 30 '06 #2

P: n/a

Thankyou so much. I finally managed to create a (very simple now I
know) one to many relationship between the tables and a query that
brings together the info I want & "autopopulates" my field. Yippee!!!

Thanks to everyone for pointing me in the right direction and showing
me what to do.

Dec 1 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.