Hi
All:
I realize this next
question is going to sound awfully simplified for this group considering I've
been working w/Access for over a year BUT....I believe Alzheimer's is setting in
and I can't seem to "get" how to do this. Here's is an
example.
Table1:
members
Table2:
contracts
Table3:
plandetails
Here
goes:
1). I have a form
that uses "contracts" as it's default table. I have 2 drop down
boxes.
2). box
1 drops down the plan type ie: standard, family, senior
etc.
3). box 2 drops
down "term length" ie: annual, semi-annual, quarterly, monthly
etc.
4). There are 2
fields I need updated. (cost & expiration Date).
4). I have a table
that has plans as rows and key, name, annual cost, semi annual cost, quarterly
cost etc as columns.
I would like to
chose a "plan" from box 1 and a "term" from box 2 and have TWO fields updated in
the contract table. Field one would be cost field two would be expiration date.
I am able to get one or the other but not sure how to get BOTH? I guess what I'm
asking is if they drop down "senior member" and "annual" how can I get the form
to know "semi-annual" is the fourth column in the table "plancosts". (The drop
down box selcts the proper "row" but How can I select a column in that
row).
I'll stop here
because I'm confusing myself let alone anyone trying to interpret this. Thanks
for ANY suggestions.
+=============+
Politically Correct is
Personally Incorrect
+=============+
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
| Microsoft access developer | Microsoft access help | Microsoft access database |
| Microsoft access training | Microsoft access training course | Microsoft access programming |
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.1/207 - Release Date: 12/19/2005
