Auto-Population, man I'm really lost!

[des-sd]

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.)

[Tom van Stiphout]

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.)

[des-sd]

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.)