Page 1 of 1

The Login program inputs Site and Sample information into the database.

Starting the program:

Go to Start - Infologic - Login, and the above window will appear.

Site Information

The top portion of the window contains all the fields pertaining to the site information.

Search for an existing site

Enter any search criteria in the corresponding box inside the site frame. Click the (Search) button to see if the site already exists in the database. A new dialogue box will prompt the search result. Click on the cell that contains the result site to bring up the site information on the main login form.

Create a new site

If the site does not already exist, a new site needs to be created. Click (New) on the main form to create a new site entry to be saved to the database. Check Copy Forward button, and then click the New button to carry over the data from the previous entry. A new site ID will be automatically assigned to the Site ID box. Enter the site information into the corresponding fields. Click Save to save the new entry to the database.
Edit an existing site
To edit an existing site, the site needs to be found. Please refer to "Search for an existing site" to find the site to be edited. Edit the site information in the corresponding fields and click Save to save the change.

Sample Information

The bottom portion of the window contains the fields pertaining to sample information. A location needs to be specified before working on Sample Information. If the location already exists, Sample Information will contain the first sample in this location. Use the arrow buttons to browse through the samples in this location.

Search for an existing Sample

Enter any search criteria in the corresponding box inside the site frame. Click the (Search) button to see if the sample already exists in the database. A new dialogue box will prompt the search result. Click on the cell that contains the result sample to bring up the sample information on the main login form.
Add a new sample
Click the (New) button. A Sample ID will be automatically assigned to the new sample. Check Copy Forward button, and then click the (New) button to carry over the data from the previous entry. Fill in the information about this sample and click (Save) to save the entry to the database.

Edit an existing Sample
To edit an existing sample, the sample needs to be found. Please refer to "Search for an existing sample" to find the sample to be edited. Edit the sample information in the corresponding fields and click (Save) to save the change.

Login Configuration

The Login program is configured in the DB_PARAMETERS table. A portion of the DB_PARAMETERS table that is used to configure Login is illustrated below. Each field included on the login screen must have a line in the DB_PARAMETERS table. The format for this line is:
Program = LOGIN Parameter = {name of site table} or {name of sample table}
Value 1 = {field name}
Value 2 = {caption}
Value 3 = T or C, T = text box & C = combo box
Value 4 = {width of text/combo box}

The last four lines in the table will contain KEY1 and KEY2 and TABLE1 and TABLE2. The KEY{x} parameters are configured as follows:
Value 1 = {field name of key for the site/sample table}
Value 2 = {key format}

The Table{x} parameters are configured as follows:
Value 1 = {site/sample table name}
Value 2 = {section caption}

Table1 and Key1 must refer to the site table and Table2 Key2 must refer to the sample table. Value1 for parameter Key1 must be the foreign key field in Table2.

Page 1 of1