K
KLR
I have a table consisting approx 400 records. Fields are Institution
Code; Name; Address.
The code is Letter followed by 2 digit number e.g. A20, B40, C25.
I have had a request from a colleague who wishes to create a new record
for a new institution, and wants the functionality of either a) prompt
to advise that code already in use (easiest option); b) display list of
available codes or c) automatically suggest a code according to
institution name (i.e. if user types in name Bedfordshire University,
the code returned will begin B## with B## being a code not already in
use.
I would appreciate some advice on how to go about creating this
functionality and opinion on how difficult it would be to create an
automatic code suggestion, or whether it would be best to have some
other method to make it easier to select a code from what in theory
could be a list of up to 2574 codes.
Help!
Code; Name; Address.
The code is Letter followed by 2 digit number e.g. A20, B40, C25.
I have had a request from a colleague who wishes to create a new record
for a new institution, and wants the functionality of either a) prompt
to advise that code already in use (easiest option); b) display list of
available codes or c) automatically suggest a code according to
institution name (i.e. if user types in name Bedfordshire University,
the code returned will begin B## with B## being a code not already in
use.
I would appreciate some advice on how to go about creating this
functionality and opinion on how difficult it would be to create an
automatic code suggestion, or whether it would be best to have some
other method to make it easier to select a code from what in theory
could be a list of up to 2574 codes.
Help!