Foreign Keys

Hi List,

Ok I apologize if this is obvious etc but .....

2 tables (trying to keep question simple)

table 1
tbl_id primary key
tbl2_acro foreign key table2.acro
other_col

table 2
acro primary key

OK person that knows what they are doing puts data into table 2

acro
Nm
aB
fiL
2 Ac
aC

ok heres the thing if someone now tries to put data into table 1 tbl2_acro
must exist in table 2. My problem is how can I get it accept the tbl2_acro
typed as eg nM, Nm or NM but still return Nm. As naturally if you type nM
or NM or nm it returns a foreign key violation. Is this possible from
the dbase level or is it more the front end level? As various users will
have various ways of tying (naturally).

Does this make sense? :)

Peter Jackson