I can find no reference to this issue anywhere, so hoping someone can help here.
I have an append query that updates a (Sales) table that has several foreign key fields. Input masks are specified in some fields on both tables. However, on one FK field in the Sales Table, the append query will not work if input masks are specified in either the table with the PK, the Sales table with the FK, or the source (Stock) table which is not joined to either table (Parent and Child tables). The other FK's with input masks from the source table don't cause any problems.
I do not understand why not. The mask in question is "AA/AAA;0;" which was created in the Wizard. The fields in question are SHORT TEXT type, field size 50 and the date entered would always be numbers, so, for example, 21/132 (they are invoice numbers)
I really don't want to store the data without a mask as it's confusing to the eye, and also I just simply can't identify the problem. If I remove the mask on all 3 tables it works fine but if I put it in any table, in any combination, I get a key violation error.
I would appreciate anyone's thoughts/suggestions.