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 |