Form combo box question

[Rob]

Is it possible to have a field in a table ( A) such as social security #

that takes a number as data. It is linked to a table (B) that has the
Name and SSN in it for the combo box drop down with appropriate
relationship. But the form for table A does not let you see the SSN
just the name but the SSN is stored in the table A.SSN. When you
click on the drop down to choose a new SSN you see both the name
and the SSN but once you choose a Name,SSN the SSN goes into the table
but the
user sees only the Name?
The property for Lookup and Bound Column and column count seem
unable to do this.
There is a simple tool in Oracle Forms that does this for you.
Thanks
Rob

[Pat]

Rob,
I'm pretty sure what you're describing is the default behavior or a combo
box. Create a simple join query for your Name and SSN so that your
returning a name field and the SSN field. Set that as your Row Source. Set
your column count to two, the column widths appropriately to be able to view
everything (name might be a bit long), and set the bound column to 1.

When you select the dropdown, you should see both the name and the SSN in
two columns, but after selecting the value, you should only see the first
column that has a width greater than 0.

If that doesn't work as you were seeking, please clarify what's missing.
HTH,
Pat
"Rob" <ro**@physics.umd.edu> wrote in message
news:41***************@physics.umd.edu...

Is it possible to have a field in a table ( A) such as social security #

that takes a number as data. It is linked to a table (B) that has the
Name and SSN in it for the combo box drop down with appropriate
relationship. But the form for table A does not let you see the SSN
just the name but the SSN is stored in the table A.SSN. When you
click on the drop down to choose a new SSN you see both the name
and the SSN but once you choose a Name,SSN the SSN goes into the table
but the
user sees only the Name?
The property for Lookup and Bound Column and column count seem
unable to do this.
There is a simple tool in Oracle Forms that does this for you.
Thanks
Rob

[Rob]

Thanks Pat you have it exactly the way I did it.
The problem is that my users would rather not see The
bound column ( SSN which is what the table calls for )
What I would like to do is have the drop down do exactly what
you are saying but after you choose the SSN,Name the Name shows
in the form box not the SSN even though the SSN is being saved at the table
level.
Obviously if I choose Name or 2 as the bound column ( Assuming my query was
written as SSN,Name (1,2) then after I choose the SSN,Name from my drop down
the table will complain because I am trying to put a text into a number
datatype.
That is not what I want. I only want to see the name at the form level but
the SSN in the table. It is really just for the end user not to have to look at
SSN.
Thanks again for the time.
Rob

[Pieter Linden]

If you only want to store the SSN but see the name, then why not set
the column width on the first column to zero?

[Pat]

Rob,
You just need to reverse the field order on your combo box. Instead of SSN,
Name (bound col 1), you want Name, SSN (bound col 2). Access will always
display the first visible field after a combo selection.

HTH - Reply back if not.
Pat
"Rob" <ro**@physics.umd.edu> wrote in message
news:41***************@physics.umd.edu...

Thanks Pat you have it exactly the way I did it.
The problem is that my users would rather not see The
bound column ( SSN which is what the table calls for )
What I would like to do is have the drop down do exactly what
you are saying but after you choose the SSN,Name the Name shows
in the form box not the SSN even though the SSN is being saved at the table level.
Obviously if I choose Name or 2 as the bound column ( Assuming my query was written as SSN,Name (1,2) then after I choose the SSN,Name from my drop down the table will complain because I am trying to put a text into a number
datatype.
That is not what I want. I only want to see the name at the form level but the SSN in the table. It is really just for the end user not to have to look at SSN.
Thanks again for the time.
Rob