I have designed an Alpha 4.5 database for a camp. The main table of the database is where the camp intake dept. enters all of the camper information from their application. Once the camper has been accepted, they use a set I developed to bring in the camper's information, then assign them a camp session. There are three tables involved... 1)Camper data... 2)Session Data.... and 3)Session Dates. In the set, SESSION DATA is the parent table. CAMPER DATA is a one-to-many link child table with "prevent changes" that links on a camper ID number which is auto-increment and unique. SESSIONS DATES is a one-to-one link.
Here's the problem. The client is calling me often with small problems. 1) A camper will just disappear from the session data after being entered. Usually when I follow up the camper's number will have been replaced by another's. This was happening before and someone suggested changing my one-to-one link to a one-to-many link and still the same result.
Second, Sometimes the auto-increment feature on the CAMPER DATA table for the camper ID does not work. One day it got stuck on a certain number and would not continue til they shut everything down and restarted.
As a final note, you should know that it is running on a network with an NT Server and Win98 workstations. They have as many as three people at a time entering data into the CAMPER DATA section. Could there be issues here?
Any help you could offer would be very much appreciated. I have tried to resolve this problem and seem to get nowhere. Thanks in advance for any help you can offer.
Here's the problem. The client is calling me often with small problems. 1) A camper will just disappear from the session data after being entered. Usually when I follow up the camper's number will have been replaced by another's. This was happening before and someone suggested changing my one-to-one link to a one-to-many link and still the same result.
Second, Sometimes the auto-increment feature on the CAMPER DATA table for the camper ID does not work. One day it got stuck on a certain number and would not continue til they shut everything down and restarted.
As a final note, you should know that it is running on a network with an NT Server and Win98 workstations. They have as many as three people at a time entering data into the CAMPER DATA section. Could there be issues here?
Any help you could offer would be very much appreciated. I have tried to resolve this problem and seem to get nowhere. Thanks in advance for any help you can offer.
Comment