AutoComplete - Advice before I start

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Peter Noneley
    #1

    AutoComplete - Advice before I start

    Hi,

    I have been asked to make a simple database. At the moment I have not
    created anything. I would like advice before starting.

    I plan to have a table of personal details called PEOPLE.

    One of the fields is the City they live in.

    I will have another table called CITY to hold all the possible City
    names.

    When I am using the PEOPLE table and entering the City I would like to
    be able to press a letter, such as B and have a list of all cities
    beginning with B appear. As I type more letters the list will focus
    in, so BR would shown Bradford and Bristol. I could then click on the
    city I want.

    My questions:

    (1) Is this possible?
    (2) Where do I start?

    Thanks.

    Peter
    Cardiff
    Wales
    UK

    Tags: None
    • storrboy
      #2
      Re: AutoComplete - Advice before I start

      On Mar 6, 6:26 pm, "Peter Noneley" <xlf...@hotmail .comwrote:
      Hi,
      >
      I have been asked to make a simple database. At the moment I have not
      created anything. I would like advice before starting.
      >
      I plan to have a table of personal details called PEOPLE.
      >
      One of the fields is the City they live in.
      >
      I will have another table called CITY to hold all the possible City
      names.
      >
      When I am using the PEOPLE table and entering the City I would like to
      be able to press a letter, such as B and have a list of all cities
      beginning with B appear. As I type more letters the list will focus
      in, so BR would shown Bradford and Bristol. I could then click on the
      city I want.
      >
      My questions:
      >
      (1) Is this possible?
      (2) Where do I start?
      >
      Thanks.
      >
      Peter
      Cardiff
      Wales
      UK
      Don't edit data directly in tables. Use a form.
      A combobox has an Auto Expand property. It is effectivley Auto
      Complete. Set this to Yes and it will do as you've requested.

        Comment

        • Peter Noneley
          #3
          Re: AutoComplete - Advice before I start

          On 6 Mar, 22:45, "storrboy" <storr...@sympa tico.cawrote:
          On Mar 6, 6:26 pm, "Peter Noneley" <xlf...@hotmail .comwrote:
          >
          >
          >
          >
          >
          Hi,
          >
          I have been asked to make a simple database. At the moment I have not
          created anything. I would like advice before starting.
          >
          I plan to have a table of personal details called PEOPLE.
          >
          One of the fields is the City they live in.
          >
          I will have another table called CITY to hold all the possible City
          names.
          >
          When I am using the PEOPLE table and entering the City I would like to
          be able to press a letter, such as B and have a list of all cities
          beginning with B appear. As I type more letters the list will focus
          in, so BR would shown Bradford and Bristol. I could then click on the
          city I want.
          >
          My questions:
          >
          (1) Is this possible?
          (2) Where do I start?
          >
          Thanks.
          >
          Peter
          Cardiff
          Wales
          UK
          >
          Don't edit data directly in tables. Use a form.
          A combobox has an Auto Expand property. It is effectivley Auto
          Complete. Set this to Yes and it will do as you've requested.- Hide quoted text -
          >
          - Show quoted text -
          Thanks for the reply and info, much appreciated.

          Peter.

            Comment

            Previous template Next
            Working...