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 having 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 below 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 ?