Simple Q on a new DB

[TomH]

Hello all. I haven't written a database in a long time as I have made a late-life transition to accounting, and need a little help with structure and relationships. I've attached a pic of the relationships to see if I've set up this simple DB correctly.

I'm just setting up an activity log for my new job as Treasurer for my new company. I want to structure it so that I can takes notes on (top level) Subjects' (sub-level) Issues. So, I might have the Subject of "International" and the Issue of "Transfer Pricing". Each Subject would have a number of Issues specific to it, and I want to log activity notes on a continuous form for each Issue. I'd like some feedback as to whether the way I have my tables would support this... and I appreciate any help!

It's amazing how one's skills deteriorate in a very short time. I'm pretty shocked that I am having to loop all the way back to, essentially, Access101 to get this done. Thanks again!

 

[plog]

tblSubjects seems pointless, but other than that looks good.

 

[TomH]

tblSubjects seems pointless, but other than that looks good.

Thanks. I was going to use that for a query on a combo box for the Subjects control. I can't remember if I have to have that relationship or not.

 

[plog]

You probably don't need it at all.

 

[TomH]

I have deleted that table now. Given the time available to think about this, I seem to remember using "cascading combo boxes" in a form... and I think that might work well here.

So, in a single form, I'd like to select the SUBJECT in a combo box control, then choose the subject-related ISSUE in another, and have a continuous (sub)form of my related notes come up and be available for additions and updates. As I remember, there was an "ON UPDATE" requery... but I cannot remember how to do it.

Like I said, it's been a long time since I did this (and cascading combos always confounded me anyway)... so any help in simplifying this already-simple database to accomplish this log is GREATLY APPRECIATED!!

Tom