Form combo box question

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

re: Form combo box question

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" <robw@physics.umd.edu> wrote in message
news:413DFEE3.C752A320@physics.umd.edu...[color=blue]
> 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
>[/color]

re: Form combo box question

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

[color=blue]
>[/color]

re: Form combo box question

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?

re: Form combo box question

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" <robw@physics.umd.edu> wrote in message
news:413F62B2.9A8564FE@physics.umd.edu...[color=blue]
> 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[/color]
table[color=blue]
> level.
> Obviously if I choose Name or 2 as the bound column ( Assuming my query[/color]
was[color=blue]
> written as SSN,Name (1,2) then after I choose the SSN,Name from my drop[/color]
down[color=blue]
> 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[/color]
but[color=blue]
> the SSN in the table. It is really just for the end user not to have to[/color]
look at[color=blue]
> SSN.
> Thanks again for the time.
> Rob
>
>[color=green]
> >[/color]
>[/color]