Parallel array

[kmuz08]

Hello to everyone,
I have to do a project in my discovering programming class based on creating parallel arrays for an order form. I am still not completely sure was a parallel array is! But basically any help, tips, pr tricks would help. My program is to allow the user to enter the name of a product, the product number or serial number, the quantity, and the cost per item and have them all displayed in different parrallel arrays. the program is also to calculate the total cost of this order in another seperate parallel array...again any responce would be helpful.

[willakawill]

Hi, a parallel array is one with the same number of elements as another array so that the same element for each array can be accessed in the same loop. A better way is to create a structure containing all of the types of data and creating an array of that structure. e.g. the parallel way

Dim ar1(25) As Integer
Dim ar2(25) As Double
Dim lp As Long
 
For lp = 0 To 25
   ar1(lp) = lp
   ar2(lp) = lp * 1.0
Next lp

And the structure way

Private Type mydata
   IDNo As Long
   Cost As Double
End Type
 
Dim MyData(25) As mydata
Dim lp As Long
 
For lp = 0 To 25
   MyData.IDNo = lp
   MyData.Cost = lp * 1.0
Next lp