Are id_product and ID Product both the same data type? (both text or both number?)
The looked up value refers to T24_po_Line_Item_PRODUCTS||id_product| and not some other table occurrence of the products table?
One test to check for a valid relationship would be to temporarily add the name field from the products table to your portal to see if the name field is displayed. If it is displayed, your relationship is valid, something is not set up correctly with the looked up value field option. If it is not displayed, your relationship has a problem.
id_product is text and id_Product is also text.
The looked up value refers to the T24_po_Line_Item_PRODUCTS||id_product| occurrence of the PRODUCTS table, which uses the id_product field as a key to relate it to the T24_pos_PO_LINE_ITEMS||id_PO| occurrence of the PO_LINE_ITEMS table, which uses the id_PO field as a key to relate it to the T24_POS occurrence of the POS table.
I dropped in a field from T24_po_Line_Item_PRODUCTS||id_product| into the portal and the field showed up, but nothing displayed in it. I then tried the same thing in another layout and portal set up for Estimates which accesses the same PRODUCTS table. It worked great. The field displayed as well as its contents.
I looked at the relationships in the Estimates tables to compare them with the relationships in the PO tables. They are the same, except for one is for Estimates and one is for PO. Here is an expanded view of the relationship between T24_pos_PO_LINE_ITEMS||id_PO| and T24_po_Line_Item_PRODUCTS||id_product|.
I then compared the lookup for the Description field in both areas. They are also the same.
For the life of me I can't see anything wrong with this.
One other thing. None of the other fields are populating either. They are using the same lookup data as the Description field is using.
I dropped in a field from T24_po_Line_Item_PRODUCTS||id_product| into the portal and the field showed up, but nothing displayed in it.
For me, that's a very key sentence in all of the above. If the field correctly displayed the name, I'd look at the looked up value settings to see what isn't working there. The blank field from products indicates that the problem is more likely with the relationship as currently defined or with the data in the actual match fields defined in these two tables. Something as simple as an extra space in the field of one table will keep that record from matching like it should to a record in the other table.
Don't know that this is exactly the issue, just listing things I would check if I had a copy of this file in front of me.
I figured it out finally. I created a new relationship between T24_pos_PO_LINE_ITEMS||id_PO| and T24_po_Line_Item_PRODUCTS||Item_Name| using Item_Name as the key. After that everything worked just fine.
Thanks again Phil for all your help. I really appreciate it!
Shouldn't need to do that. The original relationship based on the product number should work for this. You may have solved the immediate issue, but the fact that the original setup didn't work indicates you may have another problem with your database.