Hi, I'm working on a program for quoting. Whenever anyone quotes a product thats been quoted in the past I want to have a portal showing all the previous quote numbers for the product. I made a self join table and it seems to work great except that it shows the current record as well as the previous ones. Also even if a product has never been quoted in the past the table shows 1 entry with the current quote number.

eg. Someone is working on quote 18050 for product X. Product X has been previously quoted in quotes 17865, 16555, and 18001. In the table I made to show previous quotes for the product it shows: 17865, 16555, 18001, and 18050 (but I want to exclude 18050).

Another eg. Quote 19000 is quoting a new product, in the table for previous quotes it has quote 19000 listed.

Thanks for any help.

Add one more constraint to your portal relationship. (serialNo != serialNo) The not equal symbol is different in the relationships graph, but I don't know how to type it in the forum...

Not_equal sign for forum: <>. Unfortunately, the not_equal sign (equal with a slash through it) doesn't display properly--I know this from experience!

That's

:notequal:

in UBBCode.