I am a beginner, so be gentle.  I recently tried my first Browse Dialog and I am very impressed, but I want to develop a similar dialog that would allow the end user to select a specific record from a table based on criteria from several other tables.  For example, imagine a situation where we have a customer table, an invoice table, an invoice line item table, and a table containing shipping dates and addresses relating to the invoices.  I would like to use a modified Browse Dialog where the end user could enter the following criteria:

An invoice date range

A shipping date range 

A shipped to state

A product code (relating to invoice line items)

I want the end user to be able to select a specific customer record to edit from a list of customers where the list of customers is based on the criteria entered.

Hey Sam



I'm sure you'll get other answers but just to get you started, think in terms of creating a view in SQL much as you would for a report, denormalizing the data so you have a record for each line item that includes invoice and customer data. Do your search against this as all the fields will be available. Return a set that is a select distinct for the customer, if that's what your looking for and let the user select from that to return one customer record. Greg or Ivan will probably best advise as to where to intervene to return only one row for each distinct customer for the final selection but you can get started by just returning the entire result as that will work too, just will have multiple rows possibly for the chosen customer based on an invoice data range, for example.

I should add, just so there isn't any confusion, that my suggestion assumes that once you have the pk of the chosen customer you'll used that in ( event name escapes me and I can't look it up right but fires on closing the browse dialog ) to pull the customer record in the regular customerBO using FillbyPrimaryKey()



( you can also return a set of PKs and fill the CustomerBO using that - ask if want a set of customers and we can give you the code for filling based on a list of PKs returned from a browse dialog that is itself based on something other than the BO you are filling. )