AMT Datasouth Fastmark M1 Guia do Utilizador descarregar pdf (Página 305)

Database Data Source

In order to use a database with Loftware Label Manager, you must first register it with ODBC

l Start | All Programs | Loftware Labeling | Data Sources (ODBC).

Using Multiple Databases

Loftware Label Manager allows you to attach as many different databases to the label as you want. For

example, you might attach to the shipping database for ship-to address information and to the product

database for product information such as weight, description, and color.

Using Different Key Fields for Each Database Connection

When you attach multiple databases to a label, each database must have a key field so that Loftware

Label Manager knows what information to retrieve from each database. In the example above, you might

set up two separate database connections, each with their own key field. In this case, this creates two

unrelated database “lookups” by typing a Customer name and retrieving the ship to address and then

entering a part number and retrieving the product information.

Using the Same Key Field for Multiple Database Connections

Other applications may require a label to be attached to two separate databases that used the same key

field. For example, a label might retrieve some product information from a product structure file using a

part number and then look up the on-hand balance from an inventory file, also using the part number.

Loftware Label Manager can handle this case as well by making the key field for the second database

copy from the key field of the first database. This is done using the Database-Key data source dialog

boxes Get Value From/Copy From function.

Using Data from One Database as the Key to Another Database

In a third application, you may have a situation where you need a relational lookup - where data that

was returned from the initial lookup is used as a foreign key into a secondary database. This can be

accomplished by defining a secondary Database-Key field and then setting the Get Value From/Copy

From value as one of your Database-Data fields.

Relational Lookup Example

A part number database, such as LESSON2.DBF in the LLMWIN/DBASES directory contains information such as

stock numbers, descriptions, UPC numbers, finishes pertaining to the stock item. If another field was added to

the part number database, such as Customer Number, this database could be relationally linked to another,

different database containing comprehensive company address information.

Related Information

For help on registering databases with ODBC, refer to the Windows Control Panel, the ODBC section of this

guide or the Loftware Knowledge Base.

For examples and details of using multiple databases with your labels, refer to Help or the Knowledge Base .

Loftware LabelManager Version 10.1.1 User's Guide

305

1 2 ... 300 301 302 303 304 305 306 307 308 309 310 ... 531 532

Sem comentários

AMT Datasouth Fastmark M1 Guia do Utilizador Página 305