| F:\PANERIS\PARTNERS\AIRFLOW\PFE\PFETrack.mdb | Monday, April 26, 1999 |
| Table: purchase_orders | Page: 17 |
| Properties |
| Date Created: | 4/20/99 10:54:35 PM | Def. Updatable: | True |
| Description: | Purchase Orders | Last Updated: | 4/25/99 2:24:11 AM |
| OrderByOn: | False | RecordCount: | 1 |
| Columns |
| Name | Type | Size |
| id | Number (Long) | 4 |
| AllowZeroLength: | False |
| Attributes: | Fixed Size, Auto-Increment |
| Collating Order: | General |
| ColumnHidden: | False |
| ColumnOrder: | Default |
| ColumnWidth: | Default |
| Ordinal Position: | 1 |
| Required: | False |
| Source Field: | id |
| Source Table: | purchase_orders |
| organisation_key | Number (Long) | 4 |
| AllowZeroLength: | False |
| Attributes: | Fixed Size |
| Bound Column: | 1 |
| Caption: | organisation_key |
| 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: | Organisation |
| DisplayControl: | Combo Box |
| Limit To List: | False |
| List Rows: | 8 |
| List Width: | 1440twip |
| Ordinal Position: | 2 |
| Required: | True |
| Row Source Type: | Table/Query |
| Row Source: | SELECT DISTINCTROW [organisations].[ID] FROM [organisations]; |
| Source Field: | organisation_key |
| Source Table: | purchase_orders |
| purchase_order | Text | 20 |
| AllowZeroLength: | False |
| Attributes: | Variable Length |
| Collating Order: | General |
| ColumnHidden: | False |