Jump to content

Matt.C

Members
  • Content Count

    6
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Matt.C

  • Rank
    member

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    18

Platform Environment

  • OS Platform
    Windows
  • OS Version
    Win 10

FileMaker Partner

  • Certification
    Not Certified
  1. I'm trying to figure out the best way to structure my data, so that I could "merge" duplicate parent records and combine all of the child records. For example: "ABC Enterprises" has a number of child records and linked records (contact names, work orders, asset records, etc.) - meanwhile there are second and third records "ABC Enterprises Ltd." and "ABC Enterprise" that has similar child and linked records. I've attached a file with some sample records. This example is overly simple to illustrate what I'm trying to do. In real-world, each company would have many other pieces of information (address & contact info, warranty documents, etc.) across a number of different tables. I'm guessing the process would look something like delegating a "master" company record. If it's feasible, I would like to use the same process to combine other records, such as duplicate phone numbers, contacts, etc. I found a few articles online, this process is used sometimes for medical records and is apparently referred to as a "Master Patient Record" or "Master Name Index" from what I can see. What is the best way to accomplish this? Thank you! ABC sample.fmp12
  2. Thanks @comment for the demo. I hadn't thought of using portal filtering like that!
  3. I have two tables, Student and StudentPhoto, that are connected via an ID field. The portal on the student layout shows the container field (with the photo), and the photo date feidl, from the related records in StudentPhoto. I've attached an example file below showing what I've done... Thanks! Students.fmp12
  4. I'm hoping someone might be able to help, or at least point me in the right direction. I'm creating a portal that displays a student photo, but would like the ability to navigate forward/backward through the photographs in the portal without the vertical scroll bar. My < and > buttons currently point to a Go to Portal Row - Previous/Next script step. It works great when "Allow vertical scrolling" is turned on, but does not work with it turned off. It does work with Allow vertical scrolling turned on and show scroll bar set to "When scrolling", however, the scroll bar appears on mouse-over. Any suggestions on how I might be able to achieve this? Many thanks! Matt
  5. 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
  6. 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
×
×
  • Create New...

Important Information

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