11 Replies Latest reply on Jan 5, 2010 5:09 PM by thumper

    Showing only females in the database

    thumper

      Title

      Showing only females in the database

      Post

      Im wondering if there is a function to get the first letter of the input text from one table field to automatically place it into another field in the same table upon creation?

       

      I have two fields in my table:

       

      "Animal Sex"

      "Animal Sex Short"

       

      When creating a record for Male, i would like the "animal sex short" field to automatically enter "M" for data.

       

      My reason for wanting this is because when viewing a report that i made using " new report/layout", with my report i would like to have 2 buttons , one that shows only males in the database and the other shows only females in the database. I tried doing this using the perform find script to search but for some reason its not really only showing the specific gender for that button, hard to say.

       

      I fugured if i only had a single character to search for in the "animal sex short" field then the database cant confuse the search because of the text "male" is also in the word female.

       

       

       

      I just woke up so i hope this makes sence lol.