Hi all, apologies for the noob question but I’m a bit overwhelmed trying to learn FileMaker while simultaneously seeking specific answers. I’m trying to build an interactive customer database that shows multiple records in each customers file. Basically, I’m doing on-site testing of various items at locations all over the state, anywhere from 5 items to 100 items per location. Each item I test needs an individual form with the customer name, make/model, and applicable test results. Ideally, I’d like a customer database with a button of sorts that will open up my testing form where I can add as many records as needed and have them all organized within that customer’s file. Here’s where I’m at:
- i’ve created the customer database layout with a list of customer names in a portal which then shows their information. In that information, I have the button I’d like to use for the jump to the testing layout.
- I’ve created the testing layout that I’ll be using for each piece of equipment I’m testing.
I guess my question is what my next step of research should be. Should I be looking at creating a relationship between the two layouts? Should I be looking at how to create a button script? Both?
Any input is appreciated. Thanks!