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

Fields and values (Inserting values to multiple Fields)

P: 1
Hi
I need help inserting value in different fields.

So lets say I have:
Three field names:

ID-number

Next field name is
Journey

Next field name is
Weekday
-------

Next, lets fill these fields:
ID-number: Digits for each row will be auto filled as soon as values are entered on other field names.

Journey:
Lets say
First Journey is: Earth
Second Journey is: Mars
Third Journey is: Jupiter

Weekday:
I will enter a day (example Monday) for Earth (no problems here)

If I fill a Weekday for Mars, I want the database to Auto fill that data to Jupiter as well (so they are related but have different Field names).

How can I do this?
Apr 5 '12 #1
Share this Question
Share on Google+
1 Reply


100+
P: 759
This is possible.
But take a look here: http://bytes.com/topic/access/insigh...ble-structures before continue.
Why you wish to store the same data in two fields ? This has no logic.

If you don't change your mind after you read the link, come back and explain WHY you wish to do that (if you steel wish).

After all that I'll show you "how to".
Apr 6 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.