I haven't found the solution yet, I have several forms that can be used independently. I would like to go back to a record based on primary key for update at any time.
I want on current updates within the same table record created at the first form keeping the same record in focus on the many side. Then go back to that record at any time for updates.
my issue is on the many side I have the autonumber record which I have chosen duplicates along with the key added from the one side - indexed will always have a relationship.
why is access creating extra records in this case 4-5 with the primary key.
What I need is to hold one record on the many that can be updated at any time without creating 5 additional records with the same primary key. It really is not necessary to create duplicates of the primary key with partial data.
I have 5 forms, 1 main, and 4 subforms pointing to the same record, although linked to primary key, I want only one record(current) updated from the many.
How do I get and hold a record between main/subforms within the same table record. that is my question. your help is appreciated.
thank you
Ed
I want on current updates within the same table record created at the first form keeping the same record in focus on the many side. Then go back to that record at any time for updates.
my issue is on the many side I have the autonumber record which I have chosen duplicates along with the key added from the one side - indexed will always have a relationship.
why is access creating extra records in this case 4-5 with the primary key.
What I need is to hold one record on the many that can be updated at any time without creating 5 additional records with the same primary key. It really is not necessary to create duplicates of the primary key with partial data.
I have 5 forms, 1 main, and 4 subforms pointing to the same record, although linked to primary key, I want only one record(current) updated from the many.
How do I get and hold a record between main/subforms within the same table record. that is my question. your help is appreciated.
thank you
Ed
