I have a table for products with a portal to a child table with line items that make up the products in the parent table. This part is well and good however I am running into two issues and I don't seem to be able to find the answer in discussions here or in videos on youtube.
1) When I go to enter the same line item for a second product it creates a whole new entry in the line item table instead of referring back to the existing entry for that line item.
2) And I believe when the above gets corrected this will cease but there is not price information for the new line item. I suspect theses because the new entry has no pricing information, but is there a specific setting I need for it to pull the additional fields from a table entry when it is matched?