First of all I want to thank you all for taking the time of checking my problem out.
I been trying to fix this over 3 days already unsuccessfully, so I decided to find someone to help me out.
So this begins at....
I build this database for my job; I work with transportation business, so I work with a lot of paperwork that I want to relate to this database for a more simple, way to organize everything.
So, I practically Normalize the majority of my tables ( CustomerT, CompanyT, TruckT, DriverT, etc...) but I am encontering some problems at this moment.
I build a Design Form of Tabs, where I included some information that has been working pretty fine with the relationships ( CustomerT and CompanyT has been working with a search box just fine, everything being save in their tables, and I am able to search for the copanies with the search box.)
The problem comes when I try to add a subform to this tab form. It does save the information of a single truck that I already have inputed, but when I try to add a new one, it comes out like this:
"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 redifine the index to permit duplicate entries and try again."
So I though that maybe could me the table that is not letting me because Is Indexed (Ok Duplicates) ??? but when I check, it was a foreign key on it?
A bit of background about this also is that, all the boxes comes directly from a Query, cause If I had it coming directly form the tables, the Search boxes will not work?
Please let me know if you need more info, maybe pictures?
Thanks!
PS: Whoever helps me to fix this problems, will get paid. Seriously, I will pay you. No kidding.
I been trying to fix this over 3 days already unsuccessfully, so I decided to find someone to help me out.
So this begins at....
I build this database for my job; I work with transportation business, so I work with a lot of paperwork that I want to relate to this database for a more simple, way to organize everything.
So, I practically Normalize the majority of my tables ( CustomerT, CompanyT, TruckT, DriverT, etc...) but I am encontering some problems at this moment.
I build a Design Form of Tabs, where I included some information that has been working pretty fine with the relationships ( CustomerT and CompanyT has been working with a search box just fine, everything being save in their tables, and I am able to search for the copanies with the search box.)
The problem comes when I try to add a subform to this tab form. It does save the information of a single truck that I already have inputed, but when I try to add a new one, it comes out like this:
"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 redifine the index to permit duplicate entries and try again."
So I though that maybe could me the table that is not letting me because Is Indexed (Ok Duplicates) ??? but when I check, it was a foreign key on it?
A bit of background about this also is that, all the boxes comes directly from a Query, cause If I had it coming directly form the tables, the Search boxes will not work?
Please let me know if you need more info, maybe pictures?
Thanks!
PS: Whoever helps me to fix this problems, will get paid. Seriously, I will pay you. No kidding.
(
