M
Mariah
I understand that using a lookup field in a table is considered a bad thing,
and truth be told I am running into some issues and would like to get rid of
them (not able to sort alphabetically as the database is sorting based on
member's autonumber). However I am not sure what would work.
We have a members table which has names and addresses, this serves as our
base table.
We also manage a lot of different information and these have their own
tables. For instance: employment, vital statistics, mailing lists, etc.
Autonumber has been linking the members through the tables.
A query combines the surname, first and last names together from the base
table into one field called fullname.
The employment table (mailings table, vital stats table, etc) has a lookup
field that references the fullname from the query so that we can "match" the
information to the individual. While I see the name, it is really storing
the autonumber behind the name, which has been ok until now -- however new
members mean that the autonumber is not the same order as the alphabet, so we
have A showing up after T, etc.
If there is a standard way to get rid of the lookup field and reference
these people through the tables another way, what would that be?
Thanks in advance for your assistance.
and truth be told I am running into some issues and would like to get rid of
them (not able to sort alphabetically as the database is sorting based on
member's autonumber). However I am not sure what would work.
We have a members table which has names and addresses, this serves as our
base table.
We also manage a lot of different information and these have their own
tables. For instance: employment, vital statistics, mailing lists, etc.
Autonumber has been linking the members through the tables.
A query combines the surname, first and last names together from the base
table into one field called fullname.
The employment table (mailings table, vital stats table, etc) has a lookup
field that references the fullname from the query so that we can "match" the
information to the individual. While I see the name, it is really storing
the autonumber behind the name, which has been ok until now -- however new
members mean that the autonumber is not the same order as the alphabet, so we
have A showing up after T, etc.
If there is a standard way to get rid of the lookup field and reference
these people through the tables another way, what would that be?
Thanks in advance for your assistance.