Hello all

I can accomplish this with, Reports, Queries (Union Query), and subdatasheets but not FORMS (well when i do i lose the dynaset

I need to display a Continuous form listing all products from a Business Segment (this is group one) as im listing all the products, we have three types; "Assortment"(not an actual product but a group of products), "Item in assortment" (a PRODUCT that is part of an assortment) and "open stock"(a PRODUCT sold only by itself)

I would like to list all the products with some type of header as they relate to an assortment such as follows

2001 Software Category


Battle Games Asst
#26832 Risk
#26941 War

Board Games Asst
#24578 Scrabble
#24579 candy land

Kiddy Fun Pack asst
#12345 Asteroids
#23456 Frogger
#23468 Gallega

Open Stock Items
#45678 Dictionary
#56789 Spell Check
#56798 Accountant Mgr
#56799 Build a Home