natemclain
Technical User
Hello guys & gals,
I have a problem when trying to enter a new Part I get this error.
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.
Now I have looked to see if the fields are indexed. And they aren’t. The only Fields that are indexed is my MemoID, & PartCardID. The PartCardID is read from a Table/Query from the tblPartCard which is a Autonumber. Then the rest of my fields are not indexed.
How this is setup it is on my frmPartCard I have a Tab Control with 7 Pages each pages has a subform with a memo field for different departments. This holds certain info on each part. Directions and reminders for everypart. When I add a new part in the frmPartCard I can go ahead and add the Memos for each department so it gets done at the same time. But once I fill out the PartCard and start on my first Memo field it goes in just fine. As soon as I go to my second Page on the Tab Control and get done entering in my data I get that error that is in blue at the top of this message.
Now how in the world can that be happening? If there isn’t any indexing setup.
Is there a better way to do this?
Also in my first Memo Tab I use it for Price History on the part. Is there away to make the Date and Price look the same everytime it is entered into a Memo field on a Form?
Like this:
01-01-01 197.92
08-16-01 201.35
10-05-01 205.45
11-10-01 208.32
And so on?? So that everything is lined up nice and even. I can’t figure out away to “TAB” in a memo field on a form. I know that the crtl Enter goes to the next line but I have just been using the space bar to space it correctly. It would be nice if there was a way to get it all lined up.
If it would help I could put a test DB of what Im trying to do on my web server for download.
TIA
nate
I have a problem when trying to enter a new Part I get this error.
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.
Now I have looked to see if the fields are indexed. And they aren’t. The only Fields that are indexed is my MemoID, & PartCardID. The PartCardID is read from a Table/Query from the tblPartCard which is a Autonumber. Then the rest of my fields are not indexed.
How this is setup it is on my frmPartCard I have a Tab Control with 7 Pages each pages has a subform with a memo field for different departments. This holds certain info on each part. Directions and reminders for everypart. When I add a new part in the frmPartCard I can go ahead and add the Memos for each department so it gets done at the same time. But once I fill out the PartCard and start on my first Memo field it goes in just fine. As soon as I go to my second Page on the Tab Control and get done entering in my data I get that error that is in blue at the top of this message.
Now how in the world can that be happening? If there isn’t any indexing setup.
Is there a better way to do this?
Also in my first Memo Tab I use it for Price History on the part. Is there away to make the Date and Price look the same everytime it is entered into a Memo field on a Form?
Like this:
01-01-01 197.92
08-16-01 201.35
10-05-01 205.45
11-10-01 208.32
And so on?? So that everything is lined up nice and even. I can’t figure out away to “TAB” in a memo field on a form. I know that the crtl Enter goes to the next line but I have just been using the space bar to space it correctly. It would be nice if there was a way to get it all lined up.
If it would help I could put a test DB of what Im trying to do on my web server for download.
TIA
nate
