Newbie Question

  • Thread starter Thread starter FT OFFICE
  • Start date Start date
F

FT OFFICE

I was wondering if anyone knows an easy way to do this:

I have 2 tables: Deals and Packages.

Packages has my package abbreviations for each type of package we sell
(either "GK' or "QR" or "RL") as the field names. The records for each type
of deal consist of the money amounts we take for deposit on each deal. So...

GK QR RL
698 498 398
349 249 199
174 124 99

In my Deals table (form later) I first have fields for PackageType, and then
Amount. I first choose what type of Package was sold...(GK, QR, RL) then I
choose how much deposit was paid.

What I want is to limit what I see in the Amount field to what corresponds
to each PackageType.

I've tried a bunch of different DLookUp scenarios but I haven't gotten it
right yet.

Thanks for looking...

-Rob
 
Hi Rob,

Your database design is not correct. Having separate fields that describe the same type
of entity (package type) is an example of a multi-valued field. You have a one-to-many
relationship between package type and money amounts. Thus, the package types should be in
one table, and the related money amounts should be in another table. These are linked
together by including a package type foreign key in the table that you store the money
amounts in.

Once you have a proper design, you can use the idea presented in KB article 209595 to
synchronize two combo boxes:
How to Synchronize Two Combo Boxes on a Form
http://support.microsoft.com/?id=209595


Here are some links for you on database design. Brew a good pot of coffee and enjoy
reading!

http://www.datatexcg.com/Downloads/DatabaseDesignTips1997.pdf

http://www.eade.com/AccessSIG/downloads.htm (See the last download titled "Understanding
Normalization")

http://support.microsoft.com/?id=234208


Tom

_____________________________________

I was wondering if anyone knows an easy way to do this:

I have 2 tables: Deals and Packages.

Packages has my package abbreviations for each type of package we sell
(either "GK' or "QR" or "RL") as the field names. The records for each type
of deal consist of the money amounts we take for deposit on each deal. So...

GK QR RL
698 498 398
349 249 199
174 124 99

In my Deals table (form later) I first have fields for PackageType, and then
Amount. I first choose what type of Package was sold...(GK, QR, RL) then I
choose how much deposit was paid.

What I want is to limit what I see in the Amount field to what corresponds
to each PackageType.

I've tried a bunch of different DLookUp scenarios but I haven't gotten it
right yet.

Thanks for looking...

-Rob
 
Back
Top