Second Variable in Lookup/Relationship?

[chrismarriott]

Hi All,

Can you have a second variable in a lookup? What I mean is this:

One file ("Quote") showing records from another file ("Line Items") in a portal based on a "Quote Number".

I want to have another file "Purchase Order" bring records from the related file (the one used for a portal in "Quote"), but I want to show only those records that have a certain "supplier nubmer" in them.

Can you do someting along the lines of a sort and and then omit the other records? I can't figure it out for the life of me.

Any help would be greatly appreciated

[PinnWal]

If I'm understanding what you're trying to do...

Make the relationship based on the combination of the 2 fields (calculation).

Quote Number & Supplier Number

Then you'll have onlt the desired info in the portal.

[chrismarriott]

I think I'm understanding what you getting at with the calculation. Can you elaborate?

Which file would the calculation field be in or would it be in both? How would you get the field to match in both files?

I'm going to try to figure it out but if you could offer a little more info

[chrismarriott]

I figured out what you were saying!!!

Thanks. It works beautifully!

I gave you a rating of 5.

[PinnWal]

Thanx for the rating

And I definitely empathize with the hair thing