Search results

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!

Apologies. The front end and back end are split. I'll combine them and make sure the launched Form is the main form. Apologies, I forgot it ties in to AD to checks group permissions! Please hold!

Hopefully links are allowed? Loaded it to google drive. https://drive.google.com/file/d/1CObqjug5ns48QfMGbkCFsCmtSYWUG2qu/view?usp=sharing

Sure thing Guys. But it seems the database (zipped) is too large to upload @ ~8MB in size. Options to get it to you?

access database engine cannot find a record in the table with key matching. This is the current query. I'm attempting to pull in the picked combobox jobID and releaseID in to the query so the user can then fill out an order form that will be relational to tblReleaseNum. When running the...

Gina, Thank you for helping me. I would like to email you a "close" to final copy. I'd like to see what you think about, or if there are any tweaks that could be made. Would this be a possibility?