Hi,

I need to collect and present data on apartment buildings.

Each apartment can have a variety of bedroom sizes (one, two, three, etc.
bedrooms in the unit). Each bedroom size can have a variety of rents.

I want to produce a grid, with the apartment name, and then 4 columns.

1BR 2BR 3BR 4BR
apt1

apt2

In the 1BR column, I want to list each of the rents charged at apt1, and
so on. I'be been able to do this first part by making a fixed number of
fields for each bedroom size (rent-1br-a; rent-1br-b; rent-1br-c, etc.)
But I also want to produce lists of (for instance) all the rent per sqare
foot, sorted, for each bedroom size (individually), and having a bunch of
different fields seems to make that impossible.

If I was writing a program, I'd make arrays, and then I could step
through the arrays and sort out the values into columns or whatever.

I'm thinking that maybe a way to solve this problem (at least the 2nd
part) would be to set up two tables, one with the basic apartment
information, and a 2nd table for unit sizes, rents, etc. If I did that,
it would be easy to find, sort, and report data for different unit sizes,
but I'm still stuck on making my rent grid.

Thanks for any advice,

Bob

FMP7; Win 2000

The grid your referring to, what are the rows apartment numbers or
apartment building numbers?

If they are apartment numbers, I assume 1 apartment can only be either
a 1 bedroom, a 2, 3 or a 4 bedrooms. This means the apartment record
should have the fields
Rent Amount
Number of Bedrooms
BedRoom1 Rent Amt (calculated)
BedRoom2-4 Rent Amt (calculated)

You should be able to create your reports with that and still work with
the data in terms of $/square foot etc.


If the rows in the grid refer to apartment building numbers then please
explain exactly what your looking for.

"FP" <a (AT) pottnerconsulting (DOT) ca> wrote in news:1128461379.567631.33250
@g44g2000cwa.googlegroups.com:

Think of a table in a word processor, where each "row" in a table can have
one or more lines of text:

In the first column, the apartment name, address, etc.

In the 2nd column, one or more rows to display information on the 1 bedroom
units. More columns for other bedrooms (2, 3, 4)

Any complex can have any number (0 or more) of entries (rows) in each
category of 1, 2, 3, or 4 bedroom units.


Bob