| F:\PANERIS\PARTNERS\AIRFLOW\PFE\PFETrack.mdb | Monday, April 26, 1999 |
| Table: purchase_order_lines | Page: 14 |
| Collating Order: | General |
| ColumnHidden: | False |
| ColumnOrder: | Default |
| ColumnWidth: | Default |
| Description: | Purchase Order Line Number |
| DisplayControl: | Text Box |
| Ordinal Position: | 3 |
| Required: | True |
| Source Field: | purchase_order_line |
| Source Table: | purchase_order_lines |
| product_ref | Text | 20 |
| AllowZeroLength: | True |
| Attributes: | Variable Length |
| Collating Order: | General |
| ColumnHidden: | False |
| ColumnOrder: | Default |
| ColumnWidth: | Default |
| Description: | Product Reference |
| DisplayControl: | Text Box |
| Ordinal Position: | 4 |
| Required: | False |
| Source Field: | product_ref |
| Source Table: | purchase_order_lines |
| supplier_key | Number (Long) | 4 |
| AllowZeroLength: | False |
| Attributes: | Fixed Size |
| Bound Column: | 1 |
| Caption: | factory |
| Collating Order: | General |
| Column Count: | 1 |
| Column Heads: | False |
| Column Widths: | 1440 |
| ColumnHidden: | False |
| ColumnOrder: | Default |
| ColumnWidth: | Default |
| Decimal Places: | Auto |
| Default Value: | 0 |
| Description: | Supplier |
| DisplayControl: | Combo Box |
| Limit To List: | False |
| List Rows: | 8 |
| List Width: | 1440twip |
| Ordinal Position: | 5 |
| Required: | False |
| Row Source Type: | Table/Query |
| Row Source: | SELECT DISTINCTROW [organisations].[ID] FROM [organisations]; |
| Source Field: | supplier_key |
| Source Table: | purchase_order_lines |
| quantity_required | Number (Long) | 4 |
| AllowZeroLength: | False |
| Attributes: | Fixed Size |
| Collating Order: | General |