>I would like suggestions how to attack the following :
>
>I am designing a data collection database with a initial set of fields to
>use. In the future it is probable that the user will want to add new
>fields to collect, with the order of collection important. I pretty much
>decided that I could add fields using 'alter table', but wonder what
>suggestions there might be about adding data entry fields onto a form.
>
>One idea I had was to put a grid onto a form,load it via a array, and
>show the fields as column one of the grid and then do data entry onto
>column 2 and column 3 etc. Is this possible?
>
Yes, possible. I've done this via an intermediate table that contains "rotated" data. One column has field names (or display names), others values. Little bit of work, but certainly doable.