Relationships

  • Thread starter Thread starter Slim
  • Start date Start date
S

Slim

I'm trying to relate all my tables and I keep getting the
following message:
Index or primary key cannot contain a Null value
The following shows all tables and Primary Key (PK)
What am I doing wrong when I go to join the Orders and
OrderDetails tables?
Tables:
ORDERS - OrderNumber (PK), CustomerID, EmployeeID,
OrderType, OrderDate, OrderTotal, OrderDetailsNumber
ORDERDETAILS - OrderDetailsNumber (PK), OrderNumber,
ProductID, Quantity, CurrentPrice, Discount, LineAmount
PRODUCTS - ProductID (PK), ProductName,
ProductDescription, ProductCategory, UnitPrice,
UnitsinStock, ReOrderLevel
CUSTOMERS - CustomerID (PK), CompanyName,ContactLName,
ContactFName, Address, City, State, Postcode,
ContactTitle, PhoneNumber, FaxNumber, EmailAddress, Notes
EMPLOYEES - EmployeeID (PK), EmployeeSurname,
EmployeeGivenName, Address, Suburb, PhoneNumber, TFN,
StartDate, TerminationDate, YearlyBonus,
CurrentBonusPoints, Telemarketer

Any help would be much appreciated.
 
If the error occurs when you are trying to assign the field as the primary
key (upon saving), then that field has a blank (or "null") value in one or
more rows. There must be a value in each row. Ideally the _ID fields will
just be the autonumber type.

If the error occurs on trying to save the relationship update, it is
probably a missing row in the "one" side of the relationship. This is only
an issue where you are enforcing referential integrity. See "one-to-one"
and "one-to-many" relationships to learn more.
 
Hello,

at first glance, I saw no error.
So:
1) All of your tables are empty now?
2) All of your tables have yet no other index besides the PK?
3) The ORDERDETAILS.OrderNumber is a Foreign Key (FK) of ORDERS.OrderNumber.
So, ORDERDETAILS.OrderNumber is a long integer, is it?

If these assumptions are not true, try copy the database with empty tables
and associate them. If no more errors, a data error is catching you, like an
ORDERDETAILS.OrderNumber that not exists in ORDERS table

Good luck

Marcelo Scofano
 
Back
Top