Question on Saving in multiple records

[jazzscreamer]

Hello,
I have what is probably a relatively simple question. I have one form and I am looking to save the value of an object in three different records, each record is in a different table. How would I go about doing this? Thank you for any help you can provide me with.

 

[Rich]

why would you want to save the same record to three tables?

 

[jazzscreamer]

They are sort of layered

I'm looking to save it like this because I'm building a client database. So I have a client table, and each client can have multiple cases. So cases is my second table. Then each case could have multiple visits, so visits is the third table. So a couple of pieces of information is saved in all three tables. Thanks again for any help.

 

[Rich]

you only need to save the PK from the Client table as the FK in the in the Cases table, the Cases PK becomes the FK in the Visits table, is that the structure you have if so it's easier handled with subforms

 

[jazzscreamer]

Sort of

Basically there is some information that is importan to be saved each visit and still have an overall record for it also.

For instance, their address. This could change from visit to visit, but it is also important to know their previous addresses.

I have a client, case and visitation tables, but I only have one form. This form is populated from the visitation, case, and client table and I already have that set up fine. It populates with the correct values from the correct fields. However, if information is new I want the capability to save that piece of information in all 3 tables so that I have information on a visit by visit level as well as on a client by client level. I'm trying to be clear, but I know I might not be. Thank you again.