I have read and download a few of samples of how to fill fields in a from another table.
Normally alpha have a script with a combo box (the list is data from another table)and fill other fields. like in case Of customer form you have a field zip and a table called zipcodes. Open the field zip in customer and the list of zipcodes are shown to be displayed, once selected the script will help to populate fields like city and St from the zipcode table.
My case is that I have 2 fields to select data from another table.
The first is easy , the Entryno is the same as a lookup dropdown and will fill the entryno in the calling table. The second field is a simple list. Once selected I have created a set of choice statement to lookup the data matching the entryno selected above. Here is my problem I have no idea how to add to the choices what record to chose.
I belive that at ".t." in the choices is where it should be a description for matching.
The table addresschoice table have the field selectadd with formulas.
I have not been able to understand the proper syntax, Hope I can get some advice.
Question 1: what will it be the syntax at ".t." position?
Question 2: Is this the right option of lookup?
Question 3: Is there a better way of combo box to narrow the selection of addresses in the order table?
I have attached a sample DB.
Normally alpha have a script with a combo box (the list is data from another table)and fill other fields. like in case Of customer form you have a field zip and a table called zipcodes. Open the field zip in customer and the list of zipcodes are shown to be displayed, once selected the script will help to populate fields like city and St from the zipcode table.
My case is that I have 2 fields to select data from another table.
The first is easy , the Entryno is the same as a lookup dropdown and will fill the entryno in the calling table. The second field is a simple list. Once selected I have created a set of choice statement to lookup the data matching the entryno selected above. Here is my problem I have no idea how to add to the choices what record to chose.
I belive that at ".t." in the choices is where it should be a description for matching.
The table addresschoice table have the field selectadd with formulas.
I have not been able to understand the proper syntax, Hope I can get some advice.
Question 1: what will it be the syntax at ".t." position?
Question 2: Is this the right option of lookup?
Question 3: Is there a better way of combo box to narrow the selection of addresses in the order table?
I have attached a sample DB.
Comment