Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Frank Thomas: "The import function from Excel is brilliant! I was able to port a database from a foreign source into Excel and then import it directly into MySQL with your program".
Samuel Poole: "I recently downloaded and ordered MySQL Data Wizard, and I thought I would drop you a note to let you know that it is the software I needed . Well done, keep up the good work, and please accept my very best regards. Please feel free to use the contents of this e-mail along with my name, as an endorsement of your excellent product".


Add your opinion

Data Wizard for MySQL online help

  Return to chapter overview  

Lookup options

ASP.NET Generator supports lookup options. If you take two tables which are linked by a master-detail relation, you can enable lookup options for the field which represents the foreign key. Bringing the IDs stored in one table field into correlation with the names stored in another table allows the target html page to contain all the correlated data. As a result, while working with the site you will only need to select the required names instead of entering the IDs.


Select the foreign table name with data appropriated to the column data in the List table drop-down list.
Use the Key field box to specify the column with the similar data.
Select the column with data to appear in the lookup list at the List field box


The default lookup options for foreign keys are enabled respectively.



Below you can find a simple example of a script with enabled/disabled lookup options.


Let see the table:


CREATE TABLE customers (


  customer_name CHAR(30NOT NULL,

  customer_country INTEGER NOT NULL,



The next table contains the data about the customer countries:


CREATE TABLE countries (


    country_name CHAR(30NOT NULL,



The html appearance of the first table with disabled lookup option is like shown below:



This is the way the result HTML table looks when generated with lookup option enabled in the process of ASP.NET generation:


  Return to chapter overview