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!!