>I have run into a request to group a set of quotes, so that when the quote is printed, the additional quotes are grouped together under the same QuoteGroupID (which I just created). The different quotes will appear like line items in an order, or similar to that, when displayed in the Quote Form.
>
>I am thinking that one way to do this is to have a new form with a grid haviog the first column as a check box for the user to select the quote from a list of quotes, and in the grid, display enough information so that the user can identify the quotes well enough to know which ones should go together (into the same Quote Group). Has anyone done something similar to this? I'd probably put a textbox beow the grid in which the user could type in the GroupID that would go into each quote record selected.
>
>I added the column, "GroupID" to the Quotes.dbf file structure.
>The table has a unique indentifier of "QuoteID" for each record (quote) in the Quotes table.
>
>What else might I do ?

That sounds like a situation appropriate for a parent-child form. The quote group would be in one table, the individual quotes in another; the two tables might be shown in separate forms, or in different pages in a PageFrame. In any case, the "child" part would show all the children that correspond to one specific parent at a time.

Alternatively, you can show all the quotes (for all groups) at a time, and show the quotegroup in a seprate column. Some frameworks provide the option of using that column for sorting and filtering.