How do I create multiple records associated with each record of a particular table

[Gary Childress]

First off greetings everyone.



I'm new to this forum. This is my first post. My skill level with Access is probably a little above beginner but not quite intermediate. I'm pretty good at figuring stuff out but I'm not very fluent in coding or macros or expressions unfortunately. I've used coding before but it's usually codes that others have come up with in answer to other people's inquiries. I use Access a bit where I work and so far I've been able to wing things on my own but I've finally hit a brick wall and I'm stumped.

I've combed all of the access help sources I can find and haven't been able to find a satisfactory answer to this particular query:

================================================== ======================

Basically I have a form called "SWITCHBOARD". From SWITCHBOARD I can open a form named "MAIN REPORT". On MAIN REPORT there is a button which opens up a pop up form called "NOTES".

MAIN REPORT is based on a table called "MAIN REPORT TABLE". NOTES is based on a table called "NOTES TABLE".

This is what I'd like to be able to do:

When I open up MAIN REPORT and go to a record. I want to be able to make multiple notes associated with that particular, single record. Each record on MAIN REPORT therefore might have several notes associated with it. Each note will be a "memo" type field.

So let's say I go to record #47. I would like to be able to click a button and have all the notes associated with record #47 pop up along with the ability to add a new note which will be associated specifically with record #47. I don't want to see any notes for any other records, just the ones for whatever particular record I am working with on MAIN REPORT.

One last caveat. When I delete a record on MAIN REPORT, it would be nice to also delete all records in the table NOTES which are associated with that record on MAIN REPORT. But this is not an absolute necessity if it proves too difficult to implement. It is just a bit of a housecleaning measure to keep the database size relatively manageable.

Thank you very much for any help.

Sincerely,

Gary

[June7]

Are you talking about report or form objects?

If MAIN REPORT is actually a form then use a subform for the NOTES table.

If you have established relationship between tables and set the Cascade Delete option, then the related child records will go away with the parent.

[orange]

Can you post a jpg of your tables and relationships.
Sounds like you have an Issues/Records table and an associated Notes table where 1 Issue could have many Notes.

Seems to be standard Form/subform set up.

Here's a good video of this ,and I'm sure there are others,
https://www.youtube.com/watch?v=YZKN_-P6wck

good luck with your project