General information
Title:
Returning a character string into a numeric data type
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only