Switchine test from one db to another

[JIM1945]

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

[Vaughan]

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.