P
Peter
Hello everyone,
I would like to do the following.
I have a form that is meant to maintain client-location information. The
client-locations are numbered. When looking for a record the user has to be
able to find that record by either typing in the location number if known,
or be able to find the proper record by typing the location name, which
highly resembles the client name in most cases. If the record is found by
looking up the clients name (lookup field number 2), I would like the value
of lookup field number one to show the location number anyway, as if that
was used to find the proper record.
Maybe you've noticed this behaviour yourselves; when any record is found
through the use of a lookup field, if you keep pressing PageDown you see the
records moving down the sequence of the table they are in or the order they
are sorted by, but the lookup field remains static. Keeping it synchronized
with the currently shown record would be a nice touch.
If that isn't possible maybe field number one can then be emptied. Same
thing goes of course if lookup field number one is used and lookup field
number two can keep up.
Greetings,
Peter
I would like to do the following.
I have a form that is meant to maintain client-location information. The
client-locations are numbered. When looking for a record the user has to be
able to find that record by either typing in the location number if known,
or be able to find the proper record by typing the location name, which
highly resembles the client name in most cases. If the record is found by
looking up the clients name (lookup field number 2), I would like the value
of lookup field number one to show the location number anyway, as if that
was used to find the proper record.
Maybe you've noticed this behaviour yourselves; when any record is found
through the use of a lookup field, if you keep pressing PageDown you see the
records moving down the sequence of the table they are in or the order they
are sorted by, but the lookup field remains static. Keeping it synchronized
with the currently shown record would be a nice touch.
If that isn't possible maybe field number one can then be emptied. Same
thing goes of course if lookup field number one is used and lookup field
number two can keep up.
Greetings,
Peter