Check out the programming guide starting on page 124

In my example below I am looking up data from another database in the same application. I am checking to see if the elements that the retrieved data will be placed is empty if it is I transfer the data if not I check with the user first.  The part you are interested in is the Xlookup. The @fn refers to the actual application you are in use this instead of typing the complete path and file name.

I hope this starts you in the correct direction.

var vAddevinspri as string

vAddevinspri = EVInscoNamePrimary + EVInscoStreetPrimary +EVInscoCityPrimary
     + EVInscoStatePrimary + EVInscozipPrimary + EVInscophonePrimary +
     EVInscoKeyPrimary + EVInscogrpPrimary + EVInscoplanPrimary




if vAddevinspri <> "" then
{
if @AskUser("There is existing data in the Primary Ins ", "do you want to replace","existing Insurance data with Default Insurance") 
{
     
     Xlookup(@fn, patientid, "patientid", "InscoNamePrimary", EVInscoNamePrimary)
     Xlookup(@fn, patientid, "patientid", "InscoStreetPrimary", EVInscoStreetPrimary)
     Xlookup(@fn, patientid, "patientid", "InscoCityPrimary", EVInscoCityPrimary)
     Xlookup(@fn, patientid, "patientid", "InscoStatePrimary", EVInscoStatePrimary)
     Xlookup(@fn, patientid, "patientid", "InscozipPrimary", EVInscozipPrimary)
     Xlookup(@fn, patientid, "patientid", "InscophonePrimary", EVInscophonePrimary)
     Xlookup(@fn, patientid, "patientid", "InscoKeyPrimary", EVInscoKeyPrimary)
     Xlookup(@fn, patientid, "patientid", "InscogrpPrimary", EVInscogrpPrimary)
     Xlookup(@fn, patientid, "patientid", "InscoplanPrimary", EVInscoplanPrimary)

}
}
else
{
     Xlookup(@fn, patientid, "patientid", "InscoNamePrimary", EVInscoNamePrimary)
     Xlookup(@fn, patientid, "patientid", "InscoStreetPrimary", EVInscoStreetPrimary)
     Xlookup(@fn, patientid, "patientid", "InscoCityPrimary", EVInscoCityPrimary)
     Xlookup(@fn, patientid, "patientid", "InscoStatePrimary", EVInscoStatePrimary)
     Xlookup(@fn, patientid, "patientid", "InscozipPrimary", EVInscozipPrimary)
     Xlookup(@fn, patientid, "patientid", "InscophonePrimary", EVInscophonePrimary)
     Xlookup(@fn, patientid, "patientid", "InscoKeyPrimary", EVInscoKeyPrimary)
     Xlookup(@fn, patientid, "patientid", "InscogrpPrimary", EVInscogrpPrimary)
     Xlookup(@fn, patientid, "patientid", "InscoplanPrimary", EVInscoplanPrimary)


}

Quote:


There might be a cleaner way but I use the same xlookup command and use the complete path and database name. This example checks for 5 digits when exiting zipcode element and if 5 digits are present it uses the sample zip code database to return the city, state and time zone to the other app. This is not the best written validation routine example but it works as a learning tool.

// checks for at least 5 digits in zip code

If @len(@num(homezip)) < 5 then
     {@Msgbox("The ZipCode Must be" , "at least five digits." , "Please correct the entry.")

     Goto homezip
}

// see page 44 in prog guide if need to add else goto statement


      Xlookup("C:\Sesame\Data\Samples\ZipCode.db", homezip, "zip code", "city", Homecity)
      Xlookup("C:\Sesame\Data\Samples\ZipCode.db", homezip, "zip code", "state", Homestate)
      Xlookup("C:\Sesame\Data\Samples\ZipCode.db", homezip, "zip code",  "Full county", HomeCounty)
      Xlookup("C:\Sesame\Data\Samples\ZipCode.db", homezip, "zip code",  "Time Zone", HomeTZ)

Can you please describe in more detail what you are trying to do?

Thanks

Quote:


I have also faced the similar problem. In Sesame, to accomodate this, you have to have a database with two forms (In one single application).
Customer
orders

Whatever elements that you are copying now in Q&A from one database to another, make it a common elements in both forms.... bound these elements to the respective common fields.  This way when you are entering a customer in customer form, you are also entering customer# in the order form.  This way you do not have to copy anything.  Am I clear?

Bob,
He has two databases in Q&A. When he translated in Sesame, that made two separate applications. In Sesame,  one can copy value from on form to another if they the forms belong to the same application. Here he has two separate applications.  How can he copy in sesame, the same way he could do in Q&A from one database to another database? (Copy can would not work with two separate applications in Sesame.)

In Q&A, one can have multiples databases that will add record and update records using copy, mass update with programming in On record exit and On record entry form along with macors and one would not have to enter data or open that database manually.