Problem with changing Record Name with associated Portals
I have a Purchase Order Layout table, with an associated Line Items table. The Purchase Order table has a primary key field field called PO Number - this is also a key field in the line items table, so that when a Line Item is created in the Portal on the Purchase Order layout - that line item is now "married" to that PO via that PO Number field. However, I notice that if I mis-type the PO Number originally - then add a bunch of line items - then go back and fix my PO Number - all of the line items in my portal disappear. I understand that they are married to the "original" PO Number - so when I change it back to the mis-spelled one, they come back. How do I get it so that I can change the PO Number and the field in the line items changes with it (and by extension they stay on that PO no matter how many times I re-type the PO Number)? Thanks.