Hi -

I would like to have certain fields on a form returned to their parent table as a character string into a field whose data type has been declared numeric.

For example:

I have a table called office_assignment which has the following fields

nofficeassignid = numeric data type (pk)
ncontactid = numeric data type
nofficeid = numric data type

I have created a form for the office_assignment table to input data, called office_assignments. This form has the same fields on the form

nofficeassignid = pk
nofficeid = numeric data type


But, my last field is called: ncontactid

Here I created a combo box, which pulls the first and last name of the contact in the first column (this is placed in the combo box) as well as the contactid (which I have hidden), which is placed in the table.

In addition to having the contacts name appear in the combo box, I would also like for their name to appear in the table, under CONTACTID, so that I can design views and see the contacts names, not just a number.

As it stands now, the office_assignment table looks like this:

noffficeassign id nofficeid ncontactid
1 1 3
2 2 7



I would like to have the contacts name appear under ncontactid, versus seeing the numbers 3 & 7.

I hope my question is clear and not too confusing.


If anyone has any thoughts on this, I would sure like to hear them.
jason

TIA