Very Computer

I'm looking to see if anyone can give me any advice on how to make
a better input form view than seems to be currently available under
Paradox 4.5 for DOS.  What I'd like to be able to do is a make a form
view that will look like the following:

        Rec#1  Rec#2  Rec#3  Rec#4 ... Rec#20
Field1
Field2
Field3
: :  :
Field40

Near as I can tell it's not possible to have more than 23 lines on a
single Paradox 4.5 input form screen, and its also not possible to
display multiple records at the same time on such a form.  Please
correct me if I am wrong about this, Paradox isn't one of my
strong suits.

Is it possible to make such an input view using one of the newer Windows
versions of Paradox?  Preferably is there any add-on program which has
been designed which would let me do this with Paradox 4.5 for DOS?  Any
help would be greatly appreciated.

Peter van Rossum

You are attempting to show too much data on one screen, whether you're using
DOS or Windows.  You have more flexibilty using PdoxWin with notebooks and
smaller fonts, but you really need to look at your data and decide whether you
can divide it into groups.   Is all the data input at one time or is some
added later?   Is any data duplicated?   Should it all be in one table?

--
Marilyn Ainslie
Cheshire  UK
http://www.cloud9.u-net.com/

Peter: I agree with every word Marilyn said.. the
data display you are considering is more a report
spec than a table layout.. most often, this type
of layout is the result of a crosstab of a table
with three fields.. your "column" value, your
"row" value, and a "value" value.. this in turn
can be crosstabbed very easily.. and maintains a
table structure that is much easier to query..

--
Steve Green - Diamond Software Group - Waldorf Maryland USA

and Corel's CTech tech support staff, but I don't represent
Borland International or Corel in any official capacity.

Quote:>Peter: I agree with every word Marilyn said.. the
>data display you are considering is more a report
>spec than a table layout.. most often, this type
>of layout is the result of a crosstab of a table
>with three fields.. your "column" value, your
>"row" value, and a "value" value.. this in turn
>can be crosstabbed very easily.. and maintains a
>table structure that is much easier to query..
>--
>Steve Green - Diamond Software Group - Waldorf Maryland USA

While the structure you mention above of 3 fields does have utility, it
suffers from the drawback that the data entry people need to enter the field
values each time.  In the past when I've had people do this I've had to spend
a fair amount of time in error correction (and I still doubt I cleaned up
everything).  So it looks to me like maybe I'll have to do what I wanted to
avoid and look into writing a script program - or does anyone know of another
database program which would do what I originally asked.

Anyway thanks again for your input,

Pete

I agree with the other responders but, since the data collection forms
were already designed with the poor layout, why not input to a
spreadsheet?  A few macros could handle input validation ranges and
output could be to damn near any product.