Creating Dynamic multiple fields via LS

From: Phil Whyte
Category: Category 1
Date: 11 Jun 1998
Time: 17:47:11
Remote Name: iscl.demon.co.uk

Comments

HELP !!

I'm trying to create dynamic fields at the same time as creating a new document.

I have an LS agent which uses ODBC to link to an Access DB. For each particular record in the Access DB I am creating a new form based document. Each new document represents an "asset" (either PCs, Servers or Printers) for a Notes based Asset Information Application.

Filling in the appropriate single fields from the different tables is no problem. However... some of the data collected are software applications which reside in a table in the source DB. There can be any number of rows from 10 to 40 (one for each application). I am trying to put them into a table within the new document. Each table column has a separate field for Product Manufacturer, Product Name, Product Version and Software Compliance status (which will link to an external year 2000 compliance database via an ODBC DBLookup).

I will have a loop (while there are matching software records for the particular Asset record) and I need to add a new field for each software title found. Have tried to use the AppendItemValue from the NotesDocument class but it doesn't seem to help or I don't understand it. In any case, how would I use the loop incrementor value (say count) to create the required field name, e.g. SW_MAN_1, SW_MAN_2, etc. using the var count to create the field number portion.

Any pointers / help much appreciated.

Regards, Phil Whyte Integrated Software & Consultancy Ltd.

EMAIL: phil@iscl.demon.co.uk Tel: +44 1705 233 833 (UK)