Recent content by angloman

It's okay! The update query + delete query trick you mentioned works perfectly. Thank you very much for your help!

As far as I know, ProPro doesn't have any relationships set with ProPro. All of the relationships for the db are in the relationships.jpg from my original post. When I click "All relationships" under the Relationships window, all I have are the 3 tables T_ProNum, T_Productions and T_Tracking.

The child table doesn't have any children. ProPro is a linked table which is the source of the data. I don't want to delete anything from ProPro. Is that what I was about to do? I could definitely do that alternative approach if we can't figure this out.

Oh, you're right about the is null criteria. I have the child records set to cascade delete. Is that not sufficient? How can I get around this?

Hi all, With the help of some of the people here I was able to create a query that selects records from one table that have several fields which don't match with another table. The end-game with this query is to have it delete the records in table 1 that don't match records in table 2. The...

Er, nevermind. You're right I'm an idiot. Thanks for your help!

I tried that first. It gives me an error that I don't know how to get around.

Hi all, I need help constructing a find unmatched query. I don't really know what I'm doing with SQL and I think that I can only take things so far with query design view. I have two tables. T_Productions and ProPro (see attached). In Access query design, I can only specify one matching...

??? your link goes back to this post?

Hmm. I think I got it now. Thanks so much for your help!

In my example, there should be a hierarchical flow like this: Raw almonds LOT 5151451 Production 041188 transformed raw almonds into dry roasted almonds DRAL4 Production 041182 transformed DRAL4 into finished product 23046 - packaged dry roasted almonds However, I don't know how to make...

My issue is how do I link several employees back to their bosses, and their bosses to their bosses if the employee and their boss are in the same table? That's kind of what I already ran into.

Hi everyone, Long time lurker of your site. Seems like everyone is really helpful here. I am having trouble figuring out how to design a database which will allow me to track a raw material lot number through a number of productions until it reaches the final product. I then need to be able to...