Design by Sue
Registered User.
- Local time
- Today, 03:12
- Joined
- Jul 16, 2010
- Messages
- 816
I have an append query created to add files to a table from an imported excel file. The table to which I am appending (SubTBL) has a field names Observation. This field is not required. There is a relationship to another table (ObservationTBL) which has 3 records. The information I am trying to append includes 7000 records, about 4000 have observations assigned and they match the information in the ObservationTBL. The remaining 3000 have blank records for observation. When I run the append query, only those with observations are appended. The rest are not added because of "key violations". I removed the relationship between the ObservationTBL and the SubTBL and the append query runs. Then when I try to re-do the relationship it fails "Violates referential integrity rules"
To be clear:
1. The records without an observation are blank. (There are other fields in this append that have blank fields also and they are not causing any problems)
2. The field observation is NOT set to required.
What is going on here? Is it not allowing Null records? If so why and how can I correct this? Any help greatly appreciated.
Sue
To be clear:
1. The records without an observation are blank. (There are other fields in this append that have blank fields also and they are not causing any problems)
2. The field observation is NOT set to required.
What is going on here? Is it not allowing Null records? If so why and how can I correct this? Any help greatly appreciated.
Sue