I have a database that allows an individual to select an item from a drop down box and from there, to see the description of the item, and what number purchase order it relates to. The problem though is that if that item is accounted for in multiple purchase orders, i can only see the first order that it was created in. Is there a way to set up a calculation or field that will display all of the purchase orders that this item occurs in?

For example:Purchase Order Layout displays Purchase orders 1,4, and 5. Each of these orders use the item "Metropark Hanger"

In the ITEM Layout i have it arranged that a drop box menu displays items such as "Metropark Hanger, Plastic Hanger, Metal Hanger etc."

After clicking "Metropark Hanger," I need a field that displays the orders that it appears in (Orders 1,4, and 5)

Do i need to create a calculation field that allows me to do that? If so, what formula do i type in?

Edited August 26, 201015 yr by Guest

Actually, it sounds like you need a portal from Item to PO Line Item. (I assume that the PO has a relationship to a PO Line Item table and that each itemID is set in a PO Line Item record).

I tried using a portal but it didnt work. There is a relationship between the Items from the purchase order and the Item layout but it still does not display if it the item is shown in multiple purchase order. I must not be doing it right. Any suggestions?