May 5, 200322 yr I have 2db's, one is customer with all the normal info except I have fields for first oncall, second oncall and so forth. The second db are my contact lise for the different people who are my on call. The problems is I need to insert the contact name from the contact db into the customer db first oncal or second oncall field. then when i click button to go from customer db to related record in contact db, i will go to the correct contact record. Sounds simple to me, but i just cannot get it to work like it should. Any help would be greatly appricated, thanks
May 5, 200322 yr It sounds like you're using a flat file when relational is better. The "oncalls" should be in a separate file since a customer can have many.
Create an account or sign in to comment