How to create a lookup table for item costs?

[jenatjax]

I am creating a FM7 database to manage projects handled by our in-house printing department. I'm using portals to capture materials used on each job record. I would like to create a lookup table so that when the choose an item from the value list it auto-enters a specific item cost into the appropriate field. The FM7 help is pretty thin on how to create lookups. What I have been able to do seems to pull only the value from the first record in the portal. Can anyone give me some pointers? I'm stuck...

Thanks in advance,

Jen

[Fenton]

A Lookup requires a relationship. In this case it would be from a table occurrence of the line items table (which you're looking at inside the portal) to a Materials table. The relationship would be based on a Material ID.

You did not mention a Materials table, so one wonders what relationship you could be using for the Lookup's relationship.

[jenatjax]

That was precisely the problem. I thought I had done this properly but turns out I didn't. Everything is working beautifully now. Thanks much! Jen