group options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i can see that this has been covered before, but I just cant seem to get it
correct.I have created a form which is bound to a table in order that i can
input construction deficiencies on site as opposed to doing it by hand. The
form has quite a few check boxes in "option groups" which enable me to input
data. I have figured out the "option value" which display a number in my
table....but how and where can i make it display ....... option value 1 =
drywall deficiency.... option value 2 = paint deficiency.... option value 3 =
5'.....
 
The table stores the 1, 2, 3, etc. Your form or report is where you display
the narrative - drywall deficiency.... paint deficiency.... etc.
 
There are probably several other ways but I create a table with the number
and narrative fields. I include this table in my query.
You need to use a left join in case you do not have a default set and some
records do not have an option selected.
 
What Karl is describing is called a lookup table. Create one (let's call it
lkupDeficiency) with two fields, Option and Description. Populate it:

Option Description
------------------------------
1 Drywall Deficiency
2 Paint Deficiency

etc.

Then use it in the query that is your RecordSource for your report by
joining it:

SELECT [field list from main table], lkupDeficiency.Description FROM
[main_table_name] JOIN lkupDeficiency ON [main_table_name].Deficiency =
lkupDeficiency.Option
 
Ok,,,, things are slowly beginning to make more sence... (but i apologize for
not totally getting it yet)...

I have created a new table called "look up" and have changed field name 1 to
"option" and field name 2 to "Description".... I have "populated" the
list.... so i think i am sort of on the right track..... My new problem is
with the next steps.... setting the "record source",,, "linking' and
"joining" , query..all of the tables,,,records...forms....

Also in the original bound table I created,,, field name 1 is "orientation"
with value options 1 thru 4 (corresponding to N/s/e/w),,, field name 2 is
"reference" corresponding to "left/right/over/under etc with value options 1
thru 15.... the other field names in the table also have values starting at
1.... is there a way to have different "lookup values" with the same # "1" or
should i have unique values within the table?

Thank you for your help (and this forum in general)



Ron Hinds said:
What Karl is describing is called a lookup table. Create one (let's call it
lkupDeficiency) with two fields, Option and Description. Populate it:

Option Description
------------------------------
1 Drywall Deficiency
2 Paint Deficiency

etc.

Then use it in the query that is your RecordSource for your report by
joining it:

SELECT [field list from main table], lkupDeficiency.Description FROM
[main_table_name] JOIN lkupDeficiency ON [main_table_name].Deficiency =
lkupDeficiency.Option


glen said:
how do i get the narrative to display on the report? ...
Click to expand...
Click to expand...
 
No need to apologize - that's what it's all about ;-) You should create
separate lookup tables for each of those values. Since the tables are small,
and the data in them relatively static, there is no reason not to and plenty
of reasons to do so.

As for the joining, etc. - look up JOIN and RecordSource in the Access Help
files. Suggest you get a good book on Access, too, like the one's by Litwin
and Getz:

http://www.amazon.com/exec/obidos/s...?url=index=blended&field-keywords=Access+Getz

glen said:
Ok,,,, things are slowly beginning to make more sence... (but i apologize for
not totally getting it yet)...

I have created a new table called "look up" and have changed field name 1 to
"option" and field name 2 to "Description".... I have "populated" the
list.... so i think i am sort of on the right track..... My new problem is
with the next steps.... setting the "record source",,, "linking' and
"joining" , query..all of the tables,,,records...forms....

Also in the original bound table I created,,, field name 1 is "orientation"
with value options 1 thru 4 (corresponding to N/s/e/w),,, field name 2 is
"reference" corresponding to "left/right/over/under etc with value options 1
thru 15.... the other field names in the table also have values starting at
1.... is there a way to have different "lookup values" with the same # "1" or
should i have unique values within the table?

Thank you for your help (and this forum in general)



Ron Hinds said:
What Karl is describing is called a lookup table. Create one (let's call it
lkupDeficiency) with two fields, Option and Description. Populate it:

Option Description
------------------------------
1 Drywall Deficiency
2 Paint Deficiency

etc.

Then use it in the query that is your RecordSource for your report by
joining it:

SELECT [field list from main table], lkupDeficiency.Description FROM
[main_table_name] JOIN lkupDeficiency ON [main_table_name].Deficiency =
lkupDeficiency.Option


glen said:
how do i get the narrative to display on the report? ...

:

i can see that this has been covered before, but I just cant seem to
Click to expand...
get
it
correct.I have created a form which is bound to a table in order
Click to expand...
that i
can
input construction deficiencies on site as opposed to doing it by
Click to expand...
hand.
The
form has quite a few check boxes in "option groups" which enable me
Click to expand...
to
input
data. I have figured out the "option value" which display a number in my
table....but how and where can i make it display ....... option
Click to expand...
value 1
=
drywall deficiency.... option value 2 = paint deficiency.... option value 3 =
5'.....
Click to expand...
Click to expand...
Click to expand...
 
Back
Top