Ambiguous VTools response

[Lou_Reed]

Going back to a thread from a few weeks ago, I performed a V Tools search for the word Attendence in my current db. Clearly this is a misspelling. The search came up again with two instances of Attendence. The attached file has a screenshot of this.

I am just unsure what it is telling me.

I need to know why it is jamming two tables together.

The file is attached with a picture of this Vtools result.

In the middle column (Sub Object) there is seemingly a term consisting of two tables in my db
put together.

What is this about?

Respectfully,

Lou Reed

[pbaldy]

Given that the object is Relationships, I'd guess there are relationships between the 2 tables. Check out the relationship window.

[Lou_Reed]

That is what I thought also but the relationships are not named. So what do I check out?

Respectfully,

Lou Reed

[pbaldy]

There's no diagram? Can you attach the db here?

[Lou_Reed]

Here is the db in question. The attached file has it.

I just do not know what V Tools is talking about.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[pbaldy]

Click on Relationships on the Database Tools tab of the ribbon. VTools is showing you the relationships between the other 2 tables and the attendance table (because you searched for "attendance", though the spelling has changed).

[Lou_Reed]

I searched for attendence, the correct spelling is attendance. I want all incorrect spellings out of my db. How do I do it?

Respectfully,

Lou Reed

[pbaldy]

You get the above even after changing the names? Indexes would look like that, but they appear to be spelled correctly.