adyf Posted February 20, 2011 Share Posted February 20, 2011 I have an <index missing> message on a field that I'm trying to relate to in another table. I'm only trying to match the Assessors title with Assessors name on a form,this information is stored in a table called Assessors. The relationship for 'Assessor' goes from the Assessor table to the Assessments Comments table via the Rules Assessment Exam table. This should still work shouldn't it? Link to comment Share on other sites More sharing options...
adyf Posted February 21, 2011 Author Share Posted February 21, 2011 Is a relationship between two tables via another table just as valid as a direct relationship between two tables? Just want to rule this out of my above problem. Link to comment Share on other sites More sharing options...
bcooney Posted February 21, 2011 Share Posted February 21, 2011 I would suggest adding auto-enter numerical keys for all your records. You seem to be relating tables by user-entered text values (and that's a very poor design). Also, how about reading up on approaches to the relationship graph JonathanStark Blog? There are several methodologies available. Index missing is typically a sign of an unstored calc on the bottom half of a relationship. Hard to tell what you're doing, really. Link to comment Share on other sites More sharing options...
adyf Posted February 21, 2011 Author Share Posted February 21, 2011 I would suggest adding auto-enter numerical keys for all your records. For all records in all tables? Link to comment Share on other sites More sharing options...
bcooney Posted February 21, 2011 Share Posted February 21, 2011 Yes. Standard operating procedure. Then, redo your relationship to use those numeric keys. Link to comment Share on other sites More sharing options...
adyf Posted February 21, 2011 Author Share Posted February 21, 2011 Yes. Standard operating procedure. Then, redo your relationship to use those numeric keys. May I ask just one more basic question please? With my query above, how will a relationship built on numeric keys match an 'Assessors Name' from one table to an 'Assessors Name' in another and pull in 'Assessors Title'? Quite wrongly as you have pointed out I have always related matching text fields, 'Assessors Name' in this case. I'm finding database structure the hardest thing to get my head round but intend to persevere. Link to comment Share on other sites More sharing options...
bcooney Posted February 21, 2011 Share Posted February 21, 2011 Please look at the link I provided. You wouldn't match on Name. You would have the foreign key for the Assessors in the child table. Please read up on building relationships. Kachel Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4811 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now