error message: I need your help please...

[Gary]

Please help I've hit a brick wall...

Error Message. : -

"the changes you requested to the table were not successful because
they would create duplicate values in the index, primary key or
relationship. Change the data in the field or fields that contain
duplicate data, remove the index or redefine the index to permit
duplicate entries and try again "

This happens when I enter data on a subform which should be related to
the data on the main form. Please read below for a detailed breakdown
of what my little form consists of.

I am completely stuck at the moment...

I have a form, this form has 9 fields on it, and a subform. Both form
and subform get their data from the same table. I have linked the two
using the primary key of the table.

On the subform when i go to properties it says:

Link Chield Fields: ID
Link Master Fields: ID

ID is the name of the primary key in my table.

========================
the fields on the form
========================

the first 3 fields are: -

Lead Name
Source
Telephone

fields 4, 5, 6, 7, 8, and 9 are just address fields.

=====================
the subform
=====================

the subform comprises 3 fields.

Busines Name - txt box.
Business Type - drop down box.
Vat Registered? - tick box.

 

[Wayne Morgan]

By your description, you don't need a subform. Place the controls from the
subform on the main form. Draw a box around them to set them off if you want
to. You can then hide and unhide these controls instead of the subform.