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

Auto-Population, man I'm really lost!

P: n/a
Access Experts, Please help!

I have looked through ref. manuals, Google Groups on "Auto
Populate", and I am still lost.

Problem #1 My DB is 2 relational tables of (1) sales transactions of,
(2) radio stations. A transacation may/may not contain multiple radio
stations. Each radio station is in a radio market (eg. Los Angeles or
Miami). Each radio market has a ranking. A 3rd table contains all
markets and their rankings in separate columns.

I am trying to auto populate a field in the table when a combo box is
used to select the market, then the market rank is auto-populated. I
have tried to use a wizard generated form to create the auto-pop, but
that doesn't seem to work. I have read 4 pages of postings and have
gone into the Northwinds tutorial DB to find the solution but I
haven't succeeded.

Problem #2 is the market ranking table will change yearly. I
experimented and found that the target table dynamically updates when
the source table (lookup table) is altered. Can the data in the target
table be un-dynamic once it retrieves the entry from the lookup source?

The rest of my data base, forms, subforms, etc. seem to function or I
know how to get them working. These 2 problems are stopping me from
starting to enter the mounds of data sitting here.

I will appreciate any advice offered. (Other than you're over your
head...ha ha.)

Jan 14 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 13 Jan 2007 19:02:38 -0800, de****@cox.net wrote:

Re P1: you need 3 tables, because you have a many-to-many situation:
each transaction can be about multiple stations, and each station is
involved in many transactions. Without this db redesign you're going
nowhere in a hurry.
Northwind has Products M:M to Orders via Order Details.

Re P2: Yes. The same happens with Price for an Order Detail. The only
way to save the Price at the time of sale is to store it in the
OrderDetails table.

-Tom.
>Access Experts, Please help!

I have looked through ref. manuals, Google Groups on "Auto
Populate", and I am still lost.

Problem #1 My DB is 2 relational tables of (1) sales transactions of,
(2) radio stations. A transacation may/may not contain multiple radio
stations. Each radio station is in a radio market (eg. Los Angeles or
Miami). Each radio market has a ranking. A 3rd table contains all
markets and their rankings in separate columns.

I am trying to auto populate a field in the table when a combo box is
used to select the market, then the market rank is auto-populated. I
have tried to use a wizard generated form to create the auto-pop, but
that doesn't seem to work. I have read 4 pages of postings and have
gone into the Northwinds tutorial DB to find the solution but I
haven't succeeded.

Problem #2 is the market ranking table will change yearly. I
experimented and found that the target table dynamically updates when
the source table (lookup table) is altered. Can the data in the target
table be un-dynamic once it retrieves the entry from the lookup source?

The rest of my data base, forms, subforms, etc. seem to function or I
know how to get them working. These 2 problems are stopping me from
starting to enter the mounds of data sitting here.

I will appreciate any advice offered. (Other than you're over your
head...ha ha.)
Jan 14 '07 #2

P: n/a
Thanks for the help! -Joe

Tom van Stiphout wrote:
On 13 Jan 2007 19:02:38 -0800, de****@cox.net wrote:

Re P1: you need 3 tables, because you have a many-to-many situation:
each transaction can be about multiple stations, and each station is
involved in many transactions. Without this db redesign you're going
nowhere in a hurry.
Northwind has Products M:M to Orders via Order Details.

Re P2: Yes. The same happens with Price for an Order Detail. The only
way to save the Price at the time of sale is to store it in the
OrderDetails table.

-Tom.
Access Experts, Please help!

I have looked through ref. manuals, Google Groups on "Auto
Populate", and I am still lost.

Problem #1 My DB is 2 relational tables of (1) sales transactions of,
(2) radio stations. A transacation may/may not contain multiple radio
stations. Each radio station is in a radio market (eg. Los Angeles or
Miami). Each radio market has a ranking. A 3rd table contains all
markets and their rankings in separate columns.

I am trying to auto populate a field in the table when a combo box is
used to select the market, then the market rank is auto-populated. I
have tried to use a wizard generated form to create the auto-pop, but
that doesn't seem to work. I have read 4 pages of postings and have
gone into the Northwinds tutorial DB to find the solution but I
haven't succeeded.

Problem #2 is the market ranking table will change yearly. I
experimented and found that the target table dynamically updates when
the source table (lookup table) is altered. Can the data in the target
table be un-dynamic once it retrieves the entry from the lookup source?

The rest of my data base, forms, subforms, etc. seem to function or I
know how to get them working. These 2 problems are stopping me from
starting to enter the mounds of data sitting here.

I will appreciate any advice offered. (Other than you're over your
head...ha ha.)
Jan 15 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.