Posted by Nick Jaros on January 31, 2002 at 17:08:54:
I am the director of a non profit substance abuse program who is trying to put together a simple program to keep track of our clients. Here are my two problems (that I am sure have simple answers):
1- I have two tables. The main intake form lets us input all the clients information with a unique contract number. I have a second table for the clients cost of program information with some of the information found on the first table. This has a incramented number field that gives a unique number for each client. What I want to do is to open a form to edit the second tabel and when I enter the clients contract number, the program automatically inserts the rest of the clients information the is also found on the first table. I have tried to open the Paradox table and set the Contract# field to "Lookup" with automatic update all fields but this does not happen when I enter info on the second table.
2- I have created a directory filled with Adobe Acrobat files. I have created a form with buttons named for each of these files. I need to click the button and have the Acrobat document print to my printer.
Any Ideas? I am at a loss
Nick - firstname.lastname@example.org