Getting lookup list info to replace id#s

[Guest]

I'm still a little confused about the whole "lookup" table issue. From what
I can figure, you're alright as long as your table doesn't have a combobox
type control in it, but that's not really my question.

My vocab may be incorrect, but I have junction table that has pretty much
everything I need in the way of fields for a form and report. But, it uses
the id# for one field instead of the actual words (like personID instead of
their name). So, I need the form/report to show the actual name instead of
the id.

How is that done?

Thanks in advance,
CW

 

[Guest]

Just as a followup, the personID matches information either typed into a
small table OR, in one case, typed into a "value list"

Thx

 

[John Vinson]

My vocab may be incorrect, but I have junction table that has pretty much
everything I need in the way of fields for a form and report. But, it uses
the id# for one field instead of the actual words (like personID instead of
their name). So, I need the form/report to show the actual name instead of
the id.

How is that done?

Base the Report on a Query joining the junction table to both "one"
side tables.

Pull the text of the person's name from the Person table, the text of
the other table from that table.

On a Form it's best to use a Combo Box which is bound to the ID but
displays a name.

John W. Vinson[MVP]

 

[Guest]

Thanks John,

The report I understand I think. The form part I'm not really sure.
Really, the "form" is a "subform" and it (the subform) is not for data entry,
but just for data display.

Thanks again.
CW

 

[John Vinson]

Thanks John,

The report I understand I think. The form part I'm not really sure.
Really, the "form" is a "subform" and it (the subform) is not for data entry,
but just for data display.

A Subform is still a form (it's just how it's being used); and a combo
box works fine for display. Or you can base the subform on a query
joining the many-to-many table to the table containing names.

John W. Vinson[MVP]