R
Rich
Hello,
My app is used to manage servers, and track things such as hardware config,
maintenance history, etc.
The main form has server details. I have a tabbed control, with each tab
having a sub-form on it. Each tab brings up the child form. Parent and
child forms are linked on the "hostname" which is the PK/FK.
In my sub-forms, I can perform edits on the fields, but whenever I try to
move away from that record, I get en error indicating that a duplicate value
would be created. In the example of the hardware config tab, the child table
has the hostname populated for all servers in the database. So, there is a
corresponding row for each server. It's all the other fields/columns that
need updating.
How do I get Access to understand that I want to update these rows, not
create a new row?
TIA,
Rich
My app is used to manage servers, and track things such as hardware config,
maintenance history, etc.
The main form has server details. I have a tabbed control, with each tab
having a sub-form on it. Each tab brings up the child form. Parent and
child forms are linked on the "hostname" which is the PK/FK.
In my sub-forms, I can perform edits on the fields, but whenever I try to
move away from that record, I get en error indicating that a duplicate value
would be created. In the example of the hardware config tab, the child table
has the hostname populated for all servers in the database. So, there is a
corresponding row for each server. It's all the other fields/columns that
need updating.
How do I get Access to understand that I want to update these rows, not
create a new row?
TIA,
Rich