Male and Female

[Gareth]

i have a subtable holding male and female instead of
holding the text in a main table to cut down size.
however when inputing a new customer i want to have a
drop down menu to show both male and female and then
input the number representing that data into the
customers table ie

sexID sex
1 male
2 female

also to be able to go back and alter the sex from the
drop down list. Please Help

 

[Bill Crawford]

HI:

In your design of the table did you select the 'Lookup' tab for the field
name and set the 'Display Control' = Combo Box? The Row Source Type' will be
Table/Query and beside the 'Row Source' you will click the [...] button and
a query design will open up where you choose the table(s) and the fields
within them to build the choice list. Then close the query and save it. In
the 'Lookup' tab select which column is the bound column to store the
selection. Open the table in datasheet view and you'll see a dropdown tab,
click it and see the list of choices your query builds. You can set the
widths of the columns and the number or lines/rows to display at a time in
the table design area of the field. When you design forms with this field
from the table it will have the same behaviour.

any help?

 

[fredg]

i have a subtable holding male and female instead of
holding the text in a main table to cut down size.
however when inputing a new customer i want to have a
drop down menu to show both male and female and then
input the number representing that data into the
customers table ie

sexID sex
1 male
2 female

also to be able to go back and alter the sex from the
drop down list. Please Help

Gareth
Use a Combo Box.
Set the Combo RowSourceType to Value List.
Set the RowSource to
1;"Male";2,"Female"

Set the Bound Column to 1
Set the Column Count to 2
Set the Column Width property to:
0";0.75"

Set it's Control source to the table Field.

Just select the male of female from the drop-down. The value (1 or 2)
will be stored in the table.

 

[Guest]

thank you that helped tremendously!!

-----Original Message-----
HI:

In your design of the table did you select the 'Lookup' tab for the field
name and set the 'Display Control' = Combo Box? The Row Source Type' will be
Table/Query and beside the 'Row Source' you will click the [...] button and
a query design will open up where you choose the table (s) and the fields
within them to build the choice list. Then close the query and save it. In
the 'Lookup' tab select which column is the bound column to store the
selection. Open the table in datasheet view and you'll see a dropdown tab,
click it and see the list of choices your query builds. You can set the
widths of the columns and the number or lines/rows to display at a time in
the table design area of the field. When you design forms with this field
from the table it will have the same behaviour.

any help?

i have a subtable holding male and female instead of
holding the text in a main table to cut down size.
however when inputing a new customer i want to have a
drop down menu to show both male and female and then
input the number representing that data into the
customers table ie

sexID sex
1 male
2 female

also to be able to go back and alter the sex from the
drop down list. Please Help

.