Does this information set changed in the grid?
If not why not create a cursor of the result ready for printing, that way you could move through it and plank any repeated values.

Just a thought.

>table one, which holds three data fields.
>table two, which also holds three data fields.
>a relation is set from table two into table one by the field labeled: cust_id
>
>table three, holds 5 data fields
>a relation is set from table three into table two also by the field labeled cust_id
>
>on the form is one textbox (character), which the end user inputs a cust_id.
>
>also on the form is a grid (whose control source is table two - linkmaster to table three).
>
>as it goes now, the user inputs the cust_id into the textbox, and the exisitng relation will show
>the corresponding data in the grid.
>
>now what I would hope to endevour is that I could get data from table one into the grid somehow.
>
>I assumed to create an array, but have been unable to do so because of the size of the table. It states that the memory is too low
>to proceed with this function.
>
>to paint a picture, here is what I have.
>
>Table One (inventory info) - inventory code, inventory_desc, inventory_part
>
>Table Two (order info) - cust_id, inventory_part, date
>
>Table Three (client info) - cust_id, street, city, state, zip
>
>Client A has placed an order for 100 laptop shells, 100 laptop processors, 100 laptop HDDS, and 100 laptop LCDs. On the same order, they have placed an order for 1000 DVDs cases and 1000 CD cases.
>
>In table one, all the laptop items are grouped under the same inventory code, but different inventory parts.
>

>(i.e.:   INVENTORY CODE	INVENTORY DESC		INVENTORY PART
>          LP1000	Laptop Shells		LS-505
>          LP1000	Laptop Processors	LS-705
>          LP1000	Laptop HDDs		LS-1050
>          LP1000	Laptop LCDs		LS-900
>
>          DV500		DVD Cases		DVD-01
>
>          CD3671	CD Cases		CD-J01
>

>I have got the grid the way that I wish, displaying the entire order. However, does anyone have a way that the grid would only show the inventory in the grid on the first item. Thus using it as a seperator without seeing repeated Inventory codes. For instance the grid would look like this:
>

>INVENTORY CODE	INVENTORY DESC		ORDER QTY
>LP1000		Laptop Shells		100
>		Laptop Processors	100
>		Laptop HDDs		100
>		Laptop LCDs		100
>DV500		DVD Cases		1000
>CD3671		CD Cases		1000
>

>Then allow the user to click on a button placed next to an item in the grid, and it would only print out the details of that particular group based by inventory code.
>
>I have worked on a couple of ideas, but it does not seem to pan out. Any ideas would be great! I know the easiest solution would be to recode it all and append the inventory code into the order info file, but at this point it's not an option. Thanks for any assistance!!