- Nov 14, 2005
I have a list of Fields that MUST be in a Table. The data from this table is uploaded into another program. The Criteria for one of the fields is that it equals another field in the same table. Yes, I know repetitious. I am trying to figure out the best way to handle this situation. Can I make the default value in this field equal another field in the same table?? is there a formula I can put in the Default? Or do I need to handle this on the form with an Event? I would rather have a default value on the form if at all possible.