The changes you requested to the table were not successful......

aligahk06

New member
Local time
Today, 20:30
Joined
Apr 30, 2010
Messages
8
Dear All,

I wont be able to feed data to my form named (DelNoteBrkForm) which is created from Delivery_Track Query.
The thing is that if i m saving my records to the form (DelNoteBrkForm) record could not be saved.
The eroor encountered was
The changes you requested to the table werenot successful because they would create duplicate values in the index,primary key,or
relationship.Change tha data in the field or field that contain duplicate data, remove the index or redifine the index to permit
duplicate entries and try again.

Actually i want to open this form with all records from the form Delivery_Track ( There is a command button )
OPenSubForm.
Suppose i am searching Delivery No 22568 and once i click on command button opensubform then it will directly redirects us to the
DelNotebrkform and show us the corresponding Delivery No and their fields.

Attachment is for ur reference.

Please assist ?

Rgds,
Aligahk06
 

Attachments

One problem I see right off is that you do not have a normalized structure. You should not have repeating fields like Description1, UnitPrice1, Description2, UnitPrice2, etc.

I think you need to normalize your table structure FIRST before doing anything else. See this for how to normalize your database.

Also, another problem is that you are trying to use a one to many table structure in a single form view. That won't work. You would need to use a main form for the main data and then a subform for the many data that is associated with that main data.

But most of all - importantly -

Normalize.png
 
Dear Sir,

Can u plz help me in my attachment and normalize the table and make correction.I'm a newbie and really struggling with this problem.

If u help me in my attchment then it wouls be better for me to understand.

Rgds,
Aligahk06
 
Can you please submit the database in 2000 / 2003 format and then I may be able to look at it.

Thanks
 
Be guided by the structure of the data in the Northwind database created as a sample by Microsoft

You can download it from here if required:

http://www.microsoft.com/downloads/...12-0356-46a0-8da2-eebc53a68034&displaylang=en

Look at the Order Details tables and see how instead of having multiple fields for the order details it has each set of details in a different record.

Check out normalisation on http://support.microsoft.com/kb/283878.
or http://www.phlonx.com/resources/nf3/. There may be better explanations so just hunt around.
 

Users who are viewing this thread

Back
Top Bottom