Several forms for the same record (long)

[BrendaD]

I want to add information to my database using several forms. Each form relates to the same record though they will represent different tables (linked through Primary and Secondary keys).

What do I need to do to the forms that I create so that they all point to the same record?

ie: The officer fills out the Incident Report, which has a report #, and wants to add the witness‘s information (which is a separate form). How would I create the form so that the witness information is attached to the same report #?

A session variable is used to identify the officer and his level of access but he will be filling out several different reports (with different report #’s) per session.

As I mentioned, the database is already set up with the appropriate relationships.

Thank you, Brenda

 

[Cheech]

How do you assign the report number to the first form?

I would be tempted to have each form on a seperate page and just pass the report # between the pages Live long and make your kids suffer..