PK results in query
- Thread starter Robison
- Start date
spikepl
Eledittingent Beliped
- Local time
- Today, 08:14
- Joined
- Nov 3, 2010
- Messages
- 6,142
You have committed the ultimate sin - you used the tool of Beelzebub, namely look-up fields in your table. DOn't. http://access.mvps.org/access/lookupfields.htm
I just checked and I really didn't. The query in question is the qryTrophiesDetails. I have attached my database for your inspection. Just when I think I understand a LITTLe of whats going on Access dumbs me up...ugh.
S
S
- Local time
- Today, 02:14
- Joined
- Jan 23, 2006
- Messages
- 15,527
I think your relationships could be wrong --Items (EngravingTrophyDetails) to Orders.
Do you have write up about your business -- the processes and rules?
You haven't given us much information about your application or exactly what we are to look at.
This tutorial may be helpful to you.
Do you have write up about your business -- the processes and rules?
You haven't given us much information about your application or exactly what we are to look at.
This tutorial may be helpful to you.
Last edited:
- Local time
- Today, 07:14
- Joined
- Feb 19, 2013
- Messages
- 17,420
It wouldn't have anything to do with the fact that out of 26 orders, only one has a single related record in tblEngravingTrophiesDetails. The other records in tblEngravingTrophiesDetails do not have a related order - they have been orphaned and should be deleted.
I am only working with the trophy part of the table right now...My sons business has lots of products that they make, Trophies, Transfers, Engraving. I am using one large table but using several forms that feed the table.
I also have ApparelOrderDetails that is entirely different aspect to the business. He sells customer decorated apparel. Like football uniforms. This is a really big job and I am trying to develop a system but trying to keep it as simple as possible. No bells and whistles.
Not sure what is going on with the particular query.
Appreciate your assistance.
Sharon
I also have ApparelOrderDetails that is entirely different aspect to the business. He sells customer decorated apparel. Like football uniforms. This is a really big job and I am trying to develop a system but trying to keep it as simple as possible. No bells and whistles.
Not sure what is going on with the particular query.
Appreciate your assistance.
Sharon
JDraw:
My son has a small decorated apparel business in Michigan. His customers are mainly schools and sport teams. His customer come to the shop and order very specific items. He does not stock any products. The order process system I am trying to create starts with the customer, the order and the details of the order. I have broken it down to two main groups. Apparel and Engraving/Trophy.
The Trophy part is very detailed as there are so many parts that determine the order. I have done much with the engraving as there isn't as many variables to that.
I have been trying to learn this on my own from Access 2013 The Missing Manual and online help as well as a DVD tutorial I purchased.
Hopefully this will help you understand what I am trying to do. This is the only query where I used the total or group feature. Really not sure what I am doing so maybe that is the problem. Just not sure at this point.
Thanks again...People on this forum are so help but you also are VERY ADVANCE for us beginners to understand.
THANKS FOR YOUR CONSIDERATION....Sharon
My son has a small decorated apparel business in Michigan. His customers are mainly schools and sport teams. His customer come to the shop and order very specific items. He does not stock any products. The order process system I am trying to create starts with the customer, the order and the details of the order. I have broken it down to two main groups. Apparel and Engraving/Trophy.
The Trophy part is very detailed as there are so many parts that determine the order. I have done much with the engraving as there isn't as many variables to that.
I have been trying to learn this on my own from Access 2013 The Missing Manual and online help as well as a DVD tutorial I purchased.
Hopefully this will help you understand what I am trying to do. This is the only query where I used the total or group feature. Really not sure what I am doing so maybe that is the problem. Just not sure at this point.
Thanks again...People on this forum are so help but you also are VERY ADVANCE for us beginners to understand.
THANKS FOR YOUR CONSIDERATION....Sharon
