Recent content by Shortskimper

I read this Post for at least an hour. and did some experimenting. I HAVE FOUND A WAY! Between you, Doc, and ebs. I thank all of you for having the patience and saying the same thing to me 12 different ways until I was able to fully grasp / understand it! What I ended up doing - Locking...

As i read. I'm having an Ephinay. I don't need the tblJobNo in this query at all. If i only had the left join from tblReleaseNum to tblOrders. Would this allow me to safely add records to tblOrders with the proper ReleaseID? I will test this. More important, is it safe?

"But there are even lookup fields in tables that refer to tables that do not exist in this DB." I was told to gut everything as I had to shrink the DB small enough to upload, so I did. This is the reason you are seeing that. I removed everything that did not pertain to this issue. It must have...

I am re-uploading V1 of the DB with the proper left join and dataentry to Off so that way it acts the way my screenshots show.

This is qryOrders. It will allow me to put in only the first record (when a left join is applied), but will not allow me to put in more records than that with the same JobID and ReleaseID pulled in. This is the result if i attempt to continue to add records. It does not use the same JobID and...

I would never request you fix it for me. I'm attempting to understand why my form isn't doing what I expect it to do. The purpose of the form is for an individual to pull in the releaseID (making it relational) and to manually type in orders in to the OrderBody. The details table is down the...

@Pat Hartman You've previously said this "BUT, it will NEVER show more than ONE record because the tblDetails is not included in qryOrders" Could you explain why tblDetails is required to be in qryOrders and what joins should be on it and why? I'm assuming this is the many-to-many...

I have combed over your many to many DB and have done quite some googling and research and I can't seem to find a working combination(I believe i'm failing to understand the principle). I appreciate all of the resources you've given me and I will continue to try and get this working. I...

I am indeed attempting to view if orders exist as well as ADD new orders with that form. I will look at that. Thank you.

Wow Pat. I know you just gave me my answer but i'm trying to unpack all of it. I've been self-taught for the last 8 years so there are still some standard definitions that I faulter on and can't piece together. So bare with me. The left join is the proper join for this. My issue with ONLY...

I've done some quick and dirty testing Doc. It seems if the relationship between tables isn't there. It won't actually allow you to add new records from the query itself. So I think i'll still have to keep that relationship in play. Would you agree?

So you're stating because my criteria is considered validation of the Primary keys. It is no longer required to have any form of JOIN for data integrity in the query and i should remove it based on the KISS method. Am i understanding this correctly? The only thing I want to store in the orders...

Pat, Thank you for the feedback on the names. I will rename appropriately as when I initially picked the naming scheme 8 years ago. I didn't think about possible confusion with other fields in the same table! Thanks again for pointing that out. In regards to using a left join. That does work...

This makes sense to me as to the reason why i'm not seeing my desired results. I suppose i'm just lost on HOW I would break it up in to two queries to properly pull the JobID and ReleaseID I want to start the form off. The more i read you middle paragraph. I know you stated to break up the...

Success. Took A LOT of gutting it!