There has to be something simple wrong here, but I am not sure what.
I have two tables, All Requirements and Requirement Mapping. All Requirements has a PrimaryKey (ReqID) that had a unique number and has 3 other fields, all containing text. The Requirement Mapping Table has the same Primary Key (ReqID) and has numerous other fields that have the data type yes/no. I have a one to one relationship set up between the primary keys of each table. To get data into the All requirements table, I imported data from several different excel spreadsheets, all were generated the same way.
I know that the relationship i have set up is working properly, (in the Req Mapping table, when I click the + to see related information, the text for a particular ReqID is displayed), however, there are some records that when I click the +, do not display related information (i.e. the information is blank). All these were imported from the same excel file (which was created and imported the same way as the others).
I have tried re-importing the data and recreating the relationship but these result in the same results, most records work, the ones from that table, do not.
Any Ideas,
Thanks, Jason
I have two tables, All Requirements and Requirement Mapping. All Requirements has a PrimaryKey (ReqID) that had a unique number and has 3 other fields, all containing text. The Requirement Mapping Table has the same Primary Key (ReqID) and has numerous other fields that have the data type yes/no. I have a one to one relationship set up between the primary keys of each table. To get data into the All requirements table, I imported data from several different excel spreadsheets, all were generated the same way.
I know that the relationship i have set up is working properly, (in the Req Mapping table, when I click the + to see related information, the text for a particular ReqID is displayed), however, there are some records that when I click the +, do not display related information (i.e. the information is blank). All these were imported from the same excel file (which was created and imported the same way as the others).
I have tried re-importing the data and recreating the relationship but these result in the same results, most records work, the ones from that table, do not.
Any Ideas,
Thanks, Jason
