Click here to view the Frame Database menu.

Click here to view the complete Optifacts User Documentation Index.

Click here to contact us.

Introduction

This document provides instructions for using the Trace Library Link Editor.

searching and editing tracing links.

Procedure

From the Optifacts main menu:

Select Option 12 - Frame Inventory and press Enter.

Select Option 1 - Editor Utilities and press Enter.

Select Option 6 – Trace Library Link Editor and press Enter.

The  Trace Library Link Editor screen is displayed.

Image Added

Trace Master Table

• Press “Q” to query.
• Search for the frame using any of the available fields. Typically you would search for the frame name.

In our example below, we searched for the frame name FX3. We found two records for the 2 SKUs in the database. Each SKU has its own Tracing Link number. The first record is SKU 009398900701.

Image Added

• Press “N” to view the next record.

We see that the second record is SKU 009398900800.

Image Added

Now you can query the tracing link for each SKU in the lower section of the screen to see how many frame records are in the database associated with the same link.

Frame Description Table

• Press “T” to view the lower section of the screen, which is the o_frm_desc table. You can press “T” to navigate from one table to another.
• Press “Q” to query.
• Search for the tracking link number in the Tracing Link field of the tracing_master table as found in the upper section of the screen.

In the examples below, we see two frame records associated with the tracing link number 5069 for frame name FX3—one for frame color Gunmetal and one for Gold.

Image Added

Edit Mode

• To Edit, press “U” to update. The cursor will move to the first field of the table.
• Make the necessary changes.
• Press Escape to save the data.

To view and download these instructions as a PDF file, click on the following document image.

Click here to return to the top of the page..