[thelist] multiple options

[rudy]

> Now I need to insert a record with CompanyID 3 for each AreaID
> *and* FirmSizeID 1 *and* add each LocationID and each PositionID
> on the same row. (Does that make sense?!?!)

hi paul

yes, makes sense -- sorta


> I know how to use an array to insert a record for each AreaID,
> but Im not sure about how to insert a record for each AreaID which
> also contains a FirmSizeID, LocationID etc...

that's where you lost me

you need to do a loop of insert statements, so that each insert statement
looks something like

  insert into tblLookup
      (AreaID, FirmSizeID, LocationID, PositionID, TypeID)
   values
      ( 7, 1, 15, 2, 2 )

where each time the values are substituted into the statement where the
literal numbers are in the example above

if your form fields generate a collection of values like

CompanyID: 3
AreaID: 7, 17, 19, 31, 32, 45
FirmSizeID: 1
LocationID: 1, 7, 9, 13, 15
PositionID: 1, 2
TypeID: 2

then you will ahve to do some programming in the arrays to generate all the
possible and relevant combinations

make sense?


rudy