forms, tables, codes, and their relations --HELP!

B

bob v

i'm developping a database to help advise students at university and keep
track of their progress.

in the table, i have each row committed to a particular student, with their
requiremens in the columns. each requirement has a drop-down box with codes
in it. each code has a particularl meaning. i want to save the codes in the
table. the code AB means "not yet completed" (and yes, i do have a table of
codes)

HOWEVER, on the form associated with this, i also have dropdown boxes, but
in them, i want the meaning of the code to appear, but not the code.

Here's the problem : if i click on a "meaning" in the form, then the meaning
also appears in the table (not the code); conversely, if i select a code on
the table, then the code appears in the form (not the meaning). in other
words, on the form, i want it to read that "requirement x has not yet been
completed (or has been completed)," and then in the appropriate column on the
table, i want the code to read AB (or AC)

Anybody have any insights ??? any help would be greatly appreciated.

thanks.
 
D

Dirk Goldgar

In
bob v said:
i'm developping a database to help advise students at university and
keep track of their progress.

in the table, i have each row committed to a particular student, with
their requiremens in the columns. each requirement has a drop-down
box with codes in it. each code has a particularl meaning. i want
to save the codes in the table. the code AB means "not yet
completed" (and yes, i do have a table of codes)

HOWEVER, on the form associated with this, i also have dropdown
boxes, but in them, i want the meaning of the code to appear, but not
the code.

Here's the problem : if i click on a "meaning" in the form, then the
meaning also appears in the table (not the code); conversely, if i
select a code on the table, then the code appears in the form (not
the meaning). in other words, on the form, i want it to read that
"requirement x has not yet been completed (or has been completed),"
and then in the appropriate column on the table, i want the code to
read AB (or AC)

Anybody have any insights ??? any help would be greatly appreciated.

thanks.
Click to expand...

The combo box in the form should be based on a query of your table of
codes that returns both the code and the meaning. The combo box should
have 2 columns, with the first column being the code and the second
column being the meaning. Set the combo box's properties to:

Column Count: 2
Bound Column: 1
Column Widths: 0"; 3"

The width of the second column can be whatever you want it to be, not
necessarily 3", but the first column should have a width of 0 so that
it's the meaning that is displayed in the combo box.
 
Top