6. Working with Arrays, Table Fields, and Collections : Arrays
 
Share this page                  
Arrays
You can refer to an array as a whole or to an individual row or cell. (Individual columns are referenced only through the table field associated with the array.)
For the syntax to reference each part of an array, see How You Can Reference an Array (see How You Can Reference an Array).
Because an individual attribute of an array object can itself be an array variable or another reference variable, you can nest arrays and objects inside arrays. The following illustration shows an array containing a nested object: a reference variable with two attributes, represented by the fields Vendor# and Vname on the form. The array that contains this object has four attributes, represented by the headers Vendor_subform, Part#, Catalog#, and Price.
The following graphic illustrates the array as it would appear in a table field:
The following graphic illustrates a nested array. The outermost array has two attributes, shown by the headings Vendorno Col and Pricetbl. The attribute that appears in the table under the heading Pricetbl is an array of three attributes, Partno_col, Catno_col, and Price_col.