Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Perfect gender (2000)

    I'm trying to establish the best way to create a gender field. I don't want to adopt a Yes/No field, as it doesn't seem 'politically correct' to say that someone is NOT Female. I was thinking of using a number field to store either a 1 or 2, and creating a two column lookup with 1;Male, 2;Female as the data items, with the first column hidden?! This would then allow me to use an Option Group when building forms. Do you think this is the best way to deal with this, remembering that some staff will use the Datasheet to enter data? Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Perfect gender (2000)

    Is it politically correct to use 1 and 2? It implies a hierarchy - in this case Female is twice as much as Male. <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

    Apart from that, yes, you can use 1 and 2 in a numeric field, or "M" and "F" in a one-character text field.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Perfect gender (2000)

    Good point! My first thought was to use M and F in a one-character text field, but this prevents me from using an Option Group when building forms. The Option Group Wizard only allows numeric values to be returned?! Andy.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Perfect gender (2000)

    Andrew,

    I would use Hans' suggestion of M or F rather than numbers and just use a combobox to enter the data. It will cause less headscratching along the way because no one will have to remember which number applies to which gender.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •