How to: Display Embedded or Linked Data from Tables
|Visual FoxPro 9.0 SP2|
|How to: Display Embedded or Linked Data from Tables|
On a form or report, you can display linked or embedded data from General fields in a table. For example, suppose you have a product table in which each record includes a General field containing a brochure (a Word document) about a product. On a form, you could display selected information from the records — including the brochure describing the product.
To display data from a General field on a form
In the Form Designer, add an OLE Bound control to your form.
On the form, Visual FoxPro creates an object through which you can view the data at run time.
Specify the General field that contains the data by setting the object's ControlSource property.
For example, if the table name is
Inventoryand the General field name is
Current, then set the ControlSource property to Inventory.Current.
On the form, add buttons or menu commands for browsing the General field specified in the ControlSource property.
To display data from a General field on a report
Add a General field to the report.
For details, see.
When creating a report, you can link or embed pictures or icons directly into the report from an outside source using the image container. Other forms of data, such as Word documents or Microsoft Excel spreadsheets, can be included only if they were previously linked or embedded into a General field in a Visual FoxPro table.
Comment or report problem with topic