File Name: questionAnswers

File Submitter: imoree

File Submitted: 01 Apr 2012

File Category: Samples

FM Version: 11

This file demonstrates using the repeating fields in a virtual list technique.

Inspired by Bruce Robertson.

THis is not the "IDEAL" way to perform operations such as data normalization, but a technique non the less.

enjoy.

-ian

Click here to download this file

This is not a reliable implementation of a virtual list. The virtual list technique uses strictly sequential integers from 1 to N, whatever your record count is.

You are using get(RecordID), which does not work for this purpose. Record ID is not sequential. What happens if you delete the VList records and create new ones?

Also, why are there two occurrences of the Vlist table? If you are going to use an auto enter method for populating Index it should be get(recordNumber).

Or use a script and replace operation to ensure it has the right values.

You aren't performing the necessary find operation to find the related virtual list records.