I am about to loose it......
For weeks on end I have worked on adapting parts of northwind to an old existing database. After spending months trying to import an excel spreadsheet, removing invoice, inventory and other worthless parts; I am now struggling to just enter a freaking order. This programs is going to cause some property damage if I dont get some guidance. Help!
Have tables
Orders
Customers
Principals (Suppliers)
Employees
All have primary keys - on auto number - indexed no duplicates
I have a form
Order details - which I use to enter information/Orders.
Form is sourced on Orders Tbl
The form has a main section which asigns a new order ID
Sets status
Has Combo box for customers, employees, and text box for email addy and order date.
There is a sub form which is currently sourced on Orders TBL (though I have tired any and every possible version)
Sub form has text boxes for order amount, comm earned and statues
There is a combo box for Principals (Suppliers).
The issue.
When I enter a new record and try to save or close, I am given error message that duplicate values in the index, primary key or relationship. I have deleted relationships, changed primary keys, removed primary keys, etc....... Still get the message.
You can reopen through use of this form a record and change any field, IE Customer, employee, principal (Supplier) etc and it will save with out error.
What is going on? All of the indexs should be unique auto numbered, and dups not allowed, though I have tried to change this field to no avail. Help, guidance or a bullet for computer would be much appericated.
For weeks on end I have worked on adapting parts of northwind to an old existing database. After spending months trying to import an excel spreadsheet, removing invoice, inventory and other worthless parts; I am now struggling to just enter a freaking order. This programs is going to cause some property damage if I dont get some guidance. Help!
Have tables
Orders
Customers
Principals (Suppliers)
Employees
All have primary keys - on auto number - indexed no duplicates
I have a form
Order details - which I use to enter information/Orders.
Form is sourced on Orders Tbl
The form has a main section which asigns a new order ID
Sets status
Has Combo box for customers, employees, and text box for email addy and order date.
There is a sub form which is currently sourced on Orders TBL (though I have tired any and every possible version)
Sub form has text boxes for order amount, comm earned and statues
There is a combo box for Principals (Suppliers).
The issue.
When I enter a new record and try to save or close, I am given error message that duplicate values in the index, primary key or relationship. I have deleted relationships, changed primary keys, removed primary keys, etc....... Still get the message.
You can reopen through use of this form a record and change any field, IE Customer, employee, principal (Supplier) etc and it will save with out error.
What is going on? All of the indexs should be unique auto numbered, and dups not allowed, though I have tried to change this field to no avail. Help, guidance or a bullet for computer would be much appericated.
