I'll try to make this as concise as possible - I am trying to produce a "Product Proposal" database by working with a product listing and proposal line item db. Identical products exist with identical manufacturers numbers but are available from many different distributors or sources. In theses case they have identical manuf. numbers but disimilar ditributor numbers. I want to be able to select a product and then pull down from a list of distributors enabling all the associated info to be filled in accordingly. My if statement is finding matches based on Product Number and Distributor, but is only finding the first instance of a match, thereby returning the first distributors numbers but not others. What is wrong ? Only other info is the relationship that exists based on a match for Manuf. Number.

Relationships that haven't used a Go to Portal Row script step to evaluate them always give the first related record in the relationship (or the first one in the sort order if the relationship is sorted). So a calculation without a prior Go to Portal Row step will always take a look at the first related record for its evaluation.

Here's what I understand: You pick a part and you would like to then pick a specific distributor who sells that part.

If this is the case, then probably the easiest way to enable you to "drill down" would be to use a related value list tied to a popup menu. This value list would be set up to show only distributors who carry the selected part. The relationship would be created between the line items and the parts and be based on the part number. Then define a value list in the line items that only shows related records based on that relationship. Then back in your orders file, create a value list that uses the value list in the line items file.

Hope this helps.

Chuck