LookUp and Auto Enter Calculation??
Is their a way to do a LookUp and AutoEnter Calculation? The diglog box will only let you choose on or the other.
This is my dilema....When I create a new Invoice I basically do a "LookUp" on for the phone from the "customer info" table into the a phone field in the invoice table.
But there a times in the invoice where I need to replace the phone with a different one, since this "phone" field has has the "LookUp" button checked then I can no longer use the AutoEnter calculation to filter my phone ....you know to add parentesis and hyphen. Any suggestions in getting around this. Let me know if more clarification is needed. Thanks.