Data entry when using a tabbed control

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

Hello,

I am building a systems mgmt. database application.
On my main form, I have a tabbed control (my first time using this). The
tab control has 3 tabs, with each tab having a sub-form. The parent/child
relationship is based on the servername.

The tabs/forms seems to be performing as expected, except that when I enter
data into the control/sub-form, the data is not saved, even if I click on the
save, or change records. From Design View on the form, relevant properties
(Allow Edits .. Data Enter) are all "Yes", and recordset type is Dynaset.
This is the same for all 3 tabs/sub-forms.

Can anyone tell me what I'm doing wrong or help point me in the right
direction.
 
Update:

I discovered that I had mistakenly set Allow Edits to no, and this has been
corrected. I can now enter data on the form.

However on 1 tab/sub-form, which is for HW Config info (see below), I am
getting the error, "The changes you requested to the table were not
successful because they would create duplicate values in the index, primary
key, or relationship.....". I think that Access is trying to write the new
record in the child table and the hostname, which is parent table Primary
key, and child table primary key is getting duplicated, which is not allowed.


There should be a 1:1 relationship from parent to this child, HW config.

A little more detail....
Parent table has general server info (hostname, desc, IP Addr, FQDN, etc.
The child table (tabbed-control with a sub-form), in this case has disk drive
info (capacity, volumn name)

CDrivecapacity
CDriveVolumeName
DDriveCapacity
DDriveVolumnName
and so on for all drives.

ParentTable.primarykey = hostname
ChildTable.primarykey = hostname

I don't understand why this error is being raised.
 
Back
Top