Sesame can do everything QA did, only it does more efficiently.  You do not have to even index the key in Sesame.... As such there is no indexing at all in Sesame. I believe what you need is just xlookup commands..

Customer.db
(layout name -  customer)
AccountNo:

Name:
Address1:
Address2:
=====================
Invoice.db

AccountNo:

Name:
Address1:
Address2:

Just put the following code in AccountNo Element  of Invoice.db on Element exit event

If @IsNew then
                        {

                          Name = @xlookup ("data\customer.db",  AccountNo, "Customer!AccountNo",  "Name")

                         Address1 = @xlookup ("data\customer.db",  AccountNo, "Customer!AccountNo",  "Address1")

                        Address2 = @xlookup ("data\customer.db",  AccountNo, "Customer!AccountNo",  "Address2")

             }

Quote:


The best part about Sesame & Q&A is that there is no distinction between users and programmers. Users are programmers and Programmers are users !!! Practically all of us are users who could program using all the tools provided by Sesame that even neophytes can use and understand.