Walter
|
| Posted: 07/03/2002, 6:02 PM |
|
I am looking for an easy solution to the following problem:
I have a search page that when a person has selected their search critera on that page, a search results grid displays their results. One of the fields displayed is titled "Quote", and in the table below is a URL that once clicked, allows the current user to provide a quote for the previous record. The search table originally display is from the data table called "Customers". The quote information is kept in a table called "Quote". What I am looking for is the ability for the user to only provide one quote per customer. When the user selects his criteria, only the customers for which he has not given a quote to will be displayed.
I know there must be an easy solution.
I am using ASP 2.0 with templates.
Thank you,
Walter
|
|
|
 |
Andrew
|
| Posted: 07/05/2002, 4:53 AM |
|
Walter,
the problem is a bit unclear for me, but I suppose that you should build sql to display non quoted customers only. When open table for editing you should check the number of quotes for the customer (count them). To be able to do so, I suppose you should store the foreign key to Customer table in Quotes table or vice versa.
|
|
|
|
|
