button on existing field

[bv2000]

Scenario 2 files 1) PROBLEMS 2) CUSTBANK
The ID# field in Problems requires that it already be in the ID# field in Custbank. If the ID# in Problems is not already in Custbank, I want CUSTBANK to open automatically by using the 'button feature' so I can enter the ID# and related info. I do not know how to write a formula to make this happen. Any help would be greatly appreciated.

 

[drtree]

Hey,

You could a button on your entry layout that would allow a user to enter a new customer. Just have the "new customer" button open a layout that references the CustBank table (with the appropriate fields on it). The user can then enter the new customer in the Custbank table.
I usually just minimize the calling database (when I open the data entry form) and return to it upon close of the data entry layout.

HTH,

Dr Tree