I have an autonumber field as primary key in one table, foreign key in 
another.  I wanted to use leading letters for my autonumber keys since I 
am using them in several tables.  So I set the format as "HD"0, which 
produced HD1, HD2 etc., which is what I wanted.  Supposedly formats do not 
store with the value, so I should be able to use that key as the foreign 
key in another table, shouldn't I?  And yet when I try to set the field to 
lookup the foreign key, it gives a type mismatch error because it is 
including the "HD" with the number in a number field.  I have tried 
setting the format property in the offending table to match the "HD"0, but 
it still gives the error.  Does anybody know how, or if, I can make this 
work?  It is most annoying.

-DP