Jump to content
Sign in to follow this  
Matt Cudmore

Multiple Pages with Standardized Forms

Recommended Posts

I'm attempting to re-create some existing "paper" business forms in FileMaker, and have run into a bit of a challenge on how to set the forms up. I have attached a mock-up of a similar type of form, and how I'm envisioning the database structure and data-entry layout looking. Here's where I'm stuck-- If there are more than 2 involved people or  more than 2 witnesses, additional pages are required. 

In this example, there is 1 injured person and 3 witnesses, therefore 2 pages are required.

On the first page is the 1 injured person, the details, incident codes, and my first 2 witnesses.

On the second page is witness 3 - involved person, details and codes are left blank.

Because of the nature of the form, there could be incidents with multiple "involved people" and no witnesses, or 1 involved person and a bunch of witnesses.

Any suggestions?

Corporate - H&S - Incident Form - Mockup.pdf

Share this post


Link to post
Share on other sites

This is going to be convoluted, because your target format is. Off the top my head, I would first figure out how many pages will be required (max of (people involved, witnesses) / 2). Then print each page individually, using either filtered portals or an auxiliary relationship to exclude the people listed on previous pages.

Share this post


Link to post
Share on other sites

Thanks... I suspected it wasn't going to be easy. I'm working now to change how the report is populated, but may end up needing to use some type of temporary tables/records to do the linking and produce the report.

 

Cheers!

Matt

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.