Whatt does this message mean...

[djclntn]

I'm trying to break down my Tables into smaller Tables with assigning & relating Tables by ID Fields. This whole relational concept I just can't fully get under my belt & is frustrating regardless how many times I watch videos on this concept. I know that if I could only understand everything & the 3-rules in creating relational tables I could go long ways ...?



Anyway, as I said I tend to relate my tables according to ID fields, but when I attempt to create queries on more then one "relted" table often times I get this message, "No unique index found for the referenced field of the primary table." What does it mean?

[ajetrumpet]

First of all, if you're relying on rules of anykind to get your through, you've already failed. Rules are meant to be broken, as they always are anyway.

The biggest culprits in the world are developers themselves, actually.

"No unique index found for the referenced field of the primary table." What does it mean?

More than likely, it means that you're trying to query your tables in a manner that's not conducive to the way the tables were created and manipulated.

The SQL you're writing should reveal the "why" behind it, if you have it.

[hertfordkc]

Did you use autonumber to create a primary key? That should assure a unique record reference. The properties of your ID field are unknown, but apparently they are not unique.

[djclntn]

All of Primaay key in every table are autonumber

[Access_Blaster]

See if post #9 in this thread helps.

[djclntn]

Is there anyway I could send someone my whole databases & maybe they can help with relating my tables. It might be a wild request, but I might gain a better understanding. It's just finding the person who's able/willing their time.

[orange]

If you post a database, include an mdb version for those who don't have acc2007 or 2010. Suggest you create a zip.

[djclntn]

Please excuse my ignorance. How would I go about posting my db?

[hertfordkc]

There is an Attachment box displayed below the body of your text. You can use it to upload your DB after you use the Access tools to repair and compact it. You may have to zip it if the file is too large after compacting.

[orange]

see
http://www.utteraccess.com/forum/uni...-t1124122.html

[djclntn]

Thhis is my Pojects/Tasks Database. In one Table I keep track of which employee (s) works with me -- date & there hours. In another Table I track which projects I work on -- date & the amount of hours. I have 2-other Tables, 1) Employee infor & saleries & 2) Projects hourly rate. The database is designed that I'm working for someone & I get a certain percentage of the profits. That's just the basic of my datebase, but my goal is to learn/have all of my Tables be related.

Thanks to those who are given me time!

[djclntn]

Employees/Payroll Table: Daily Task Table:
- EmployeesPayrollID - DailyTasksID
- EmployeeInfoID - ProjectsTableID
- DailyTaskID - MNTH/YR
- Employee_ID - QRTLY
- MNTH/YR - WKDY
- QRTLY - TDATE
- WDAY - ProjectID
- TDATE - APPLCTNS
- HRS - FileName
- D/E - NOTES/TASKS
- DNW - HRS
- CMPLTD

*The 2-Tables I’ve related by the DailyTasksID
*From these 2-Tables I want to see the camparison between A) Employes HRS & B) Projects HRS on the same TDATE
*I pulled, MNTH/YR, TDATE, & HRS (Sum) from the Employees/Payroll Table -&- HRS (Sum) from the Projects/Tasks Table. When I tried to run the query I get, “No unique index found for the referenced field of the primary table." ...?

[djclntn]

Wait, I really screwed that thread up by trying to put my 2-Tables in 2-columns...bad move. I'll try this:

[djclntn]

This is better:

Employees/Payroll Table:
- EmployeesPayrollID
- EmployeeInfoID
- DailyTaskID
- Employee_ID
- MNTH/YR
- QRTLY
- WDAY
- TDATE
- HRS
- D/E
- DNW

DailyTasks Table:
- DailyTasksID
- ProjectsTableID
- MNTH/YR
- QRTLY
- WKDY
- TDATE
- ProjectID
- APPLCTN
- FileName
- NOTES/TASK
- HRS
- CMPLTD

*The 2-Tables I’ve related by the DailyTasksID
*From these 2-Tables I want to see the camparison between A) Employes HRS & B) Projects HRS on the same TDATE
*I pulled, MNTH/YR, TDATE, & HRS (Sum) from the Employees/Payroll Table -&- HRS (Sum) from the Projects/Tasks Table. When I tried to run the query I get, “No unique index found for the referenced field of the primary table."

[hertfordkc]

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< <<<<<<<

Employees/Payroll Table:
- EmployeesPayrollID
- EmployeeInfoID
- DailyTaskID
- Employee_ID
- MNTH/YR
- QRTLY
- WDAY
- TDATE
- HRS
- D/E
- DNW

DailyTasks Table:
- DailyTasksID
- ProjectsTableID
- MNTH/YR
- QRTLY
- WKDY
- TDATE
- ProjectID
- APPLCTN
- FileName
- NOTES/TASK
- HRS
- CMPLTD

*The 2-Tables I’ve related by the DailyTasksID
*From these 2-Tables I want to see the camparison between A) Employes HRS & B) Projects HRS on the same TDATE
*I pulled, MNTH/YR, TDATE, & HRS (Sum) from the Employees/Payroll Table -&- HRS (Sum) from the Projects/Tasks Table. When I tried to run the query I get, “No unique index found for the referenced field of the primary table."
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.
You say you've "pulled" MNTH/YR, TDATE, & HRS (Sum). You have a query that did this and computed a sum????

And another query that computes a sum from the Projects/Tasks Table?

And you are trying to run a third query on what?

Your post suggests that you have some success, but are missing the end result. Can you post the SQL from the queries you have so far?