Hi,
Can you provide an example to create a new custom field with a celltype of lookup?
In my specific requirement, I am wanting a debtor custom field which looks up the Branch (sales division) search window.
In your answer, can you also give a list of what different lookups are available? Back in the old days, I got this list several years ago (I note it doesn't include the branch!)
jswInventory = 1
jswDebtors = 2
jswSalesOrder = 3
jswTransfer = 4
jswGeneralLedger = 5
jswLedgerJournals = 6
jswDebtorbatchtrans = 7
jswDebtorAutoTrans = 8
jswCreditorBatchTrans = 9
jswCreditorAutoTrans = 10
jswCreditor = 11
jswCostChange = 12
jswPurchaseOrder = 13
jswDeliveryDocket = 14
jswPurchaseInvoice = 15
jswAssembly = 16
jswCashbook = 17
jswLedger = 30
jswStaff = 31
jswgroup = 32
jswContactPostion = 33
jswCredPayments = 34
jswCreditorClassification = 35
jswFXRate = 36
jswTaxRate = 37
jswWarehouseTransfer = 38
jswGLAutoJournals = 39
jswGLCategory = 40
jswBackOrderAlloc = 41
jswInventoryClassification = 42
jswDebtorClassification = 43
jswInventoryCatagory = 44
jswDuty = 45
jswBinLocation = 46
jswFreight = 47
jswQuotes = 48
jswSupplierWarehouse = 49
jswPhysicalWarehouse = 50
jswContacts = 51
jswShipments = 52
jswShipmentBookIns = 53
jswSystemPeriodRollOvers = 54
jswStockTake = 55
jswBankReconciliation = 56
jswStandardCost = 57
jswLogicalWarehouse = 58
jswMenus = 59
jswIcons = 60
jswProfiles = 61
jswJobCostCode = 62
jswPriceSchemes = 63
jswQuoteBatches = 64
jswB2BSalesOrder = 65
jswInventoryCatagory1 = 66
jswInventoryCatagory2 = 67
jswInventoryCatagory3 = 68
jswInventoryCatagory4 = 69
jswInventoryCatagory5 = 70
jswSkillLevels = 71
jswSkills = 72
jswDepartments = 73
jswWarehouseTransferOut = 74
jswWarehouseTransferin = 75
jswWarrantyItem = 76
jswMaintenanceAgreement = 77
jswServiceItem = 78
jswJobMaintenance = 79
jswSupplierReturnCredit = 80
jswSupplierReturnShipping = 81
jswSupplierReturnRequest = 82
jswManufacturingRequisitions = 83
jswBillOfMaterials = 84
jswServiceManager = 85
jswPaymentTypes = 86
jswDebtorSystemProperties = 87
jswDebtorCategory1 = 88
jswDebtorCategory2 = 89
jswDebtorCategory3 = 90
jswDebtorCategory4 = 91
jswDebtorCategory5 = 92
jswDebtorSystemTemplates = 93
jswDebtorSystems = 94
jswSupportPacks = 95
jswEmailMessages = 96