Won't someone please help? I have succeeded in Incrementing a field called EquipID in tblActiveEquipment using DMax(EquipID + 1) in an Append query but now find I need to reference a second table (Archive) to ensure the next Available Equip Number is updated in the first table. I tried adding the Archive table to the query grid (the fields are joined one to one)and query does not update however there is no error message box. How do I correctly reference two tables? Any help greatly appreciated.

[This message has been edited by Jerry Stoner (edited 11-09-2001).]

Thank you all for NOT answering and I do mean that. Forced me to look at database design and realise there were fundamental problems. Redesigned Table structures and all is well.