make a Field returnsu foriegn key value, not foriegn key id

  • Thread starter Thread starter laroygreen
  • Start date Start date
L

laroygreen

Good day,

What I want to do is a little bit more complicated than the title.

I have a form that has an embedded sub form. I use a drop down in the
form to affect the values in the sub form. This works fine, however my
problem is that some fields which are foriegn keys, return the exact
field value (which i dont want). How can I change this so that when I
change the drop down in the form, the values in the subform are actual
values, not FK keys? Thanks for your help.

Regards.
 
Good day,

What I want to do is a little bit more complicated than the title.

I have a form that has an embedded sub form. I use a drop down in the
form to affect the values in the sub form. This works fine, however my
problem is that some fields which are foriegn keys, return the exact
field value (which i dont want). How can I change this so that when I
change the drop down in the form, the values in the subform are actual
values, not FK keys? Thanks for your help.

Regards.
Click to expand...

not sure I entirely follow, but you can change the combobox so that it
shows a different field's value than the one that's stored. Set the
columns count to two (or more), and set the width of the leftmost
column to zero.
 
Thanks for your help, but i realized I only needed to use a lookup
field. Sorry, not very familiar with access databases.

Regards.
 
Back
Top