query

[Guest]

I've created a call table, staff table.
A form is created where users will input call info. They will select the
staff name, dept name etc. After they've selected the staff name, I want the
corresponding staff id to be captured in the call table instead of the actual
name. How to do it?

Thanks in advance...

 

[Steve Schapel]

Asa,

Make a combobox on the Call form, bound to the Staff id field. Use the
Staff table as the Row Source of this combobox. This is one of the
properties of the combobox. Then, you can adjust other properties of
the combobox to get the result you want. For example, if the first 2
fields in the Staff table are Staff Id and Staff Name, then set the
Column Count property of the combobox to 2, the Bound Column property to
1, and the Column Widths property to 0;3.5 (or, instead of 3.5, whatever
number will be wide enough to show the staff names in the combobox's
drop-down list). You might also need to adjust the List Width property.