-=> Quoting Bryan Hanks to Tony Toews <=-
 TT> Yes, you do need the crop table.  Or you should.  Or at least it will
 TT> save a lot of time and ensure valid data.
 BH> Then use it as a lookup table, but it has nothing to do with
 BH> formatting your report as you requested.
Yes, the crop table is required if you choose to setup a relational type
of system instead of a kludge.
Matthew Johnson's reply was pretty good.
 
 BH> Set up a report with the following:
 
 TT> Good solution but, as per my other response, what happens if the
 TT> grower has more than 5 crops?  Like 20 or 40.
 BH> 
 BH> Well, you can either expand the number of IIF lines to include
 BH> your maximum number of crops, or if the number is large (and you
 BH> don't know how large), then you'll have to write a procedure.
Why?  By changing the design of the tables to a proper relational system
all these problems go away and no IIF lines or procedures are required.
Tony
--- Blue Wave/Max v2.12 [NR]
---------------