ISelectionForeignKey Property |
Namespace: SuperOffice.COM.SuperOfficeDB
ForeginKey
This text may be copied to the notepad, and saved as a *.vbs file. Remember to change the login information.
Search the contact table for the first record that has an OrgNr that starts with 979& Returns a message box with the Contact name.
Dim objSO Set objSO = CreateObject("SuperOfficeDB.Database") Set objSOApp = CreateObject("SuperOffice.Application") If not (objSO is nothing) Then objSO.Login "<userID>", "<password>" if objSOApp.currentSelection.Identity <> 0 then set mySelection = objSo.GetSelection(objSOApp.CurrentSelection.Identity) mySelection.ForeignKey.Set "MyApplication", "MyDevice", "MyKey", "This is my foreignKey" MsgBox mySelection.Name & " has the following foreginKey set: " & mySelection.ForeignKey.Get ("MyApplication", "MyDevice", "MyKey") else msgbox "Mark a Selection and try again" end if else MsgBox "Unable to connect to database" end if Set objSO = Nothing