Help with updating a group of records from 1 field please
Can someone point me in the right direction:
I have set up a form for a contact database, on this form is a portal to another database which is related by a unique record number and this stores different phone numbers related to the single contact.
I enter the contact name on the main form in a field in the main database then I use the portal to enter records directly to the portal link database.
Once I enter the data into the portal row I need, it updates the numbers database and creates the record and it adds the contact name and unique number as an auto look up based on the relationship
the portal then lists all the data linked to the main database record.
This all works fine and I can add and delete records in the portal, or if I delete the main record it deletes all the related portal records from the second database.
The problem comes if I change the name on the main record, it doesn't then update all the linked portal records???
I am trying to figure out why. I think it is a relationship issue and have been trying stuff since last night but my brain is starting to go foggy!
Can anyone point me in the right direction if they understand what I mean,