Just add the table already
There’s this one little remnant of "6-think" that has stuck with me. I like to think of myself as no longer beholden to the limits contained in that earlier version. Yet for some reason I have this aversion to adding tables to an application. I’m fairly certain this is a hangover from the 50 file/table limit in FMP 6 days. Despite my data modeling indoctrination whenever I encounter a problem, whether it be in a solution I’m building or that of someone else, my last thought is to add a table to "normalize" that data.
Creating multiple child records from a list
Problem
You want to create child records from a list of values in a set of parent records
Solution
Create a loop-within-a-loop FileMaker script; use the power of indexed variables
Architects & Builders
Working at inRESONANCE taught me a number of things about software development that I hadn’t learned as an independent developer. As an independent you are responsible for everything - business development, project specification, design, coding, testing, bug fixing, installation, support, billing, and everything else you never thought of. If you’re not proficient at one or more of those things, say billing clients for work you’ve done, you’re not going to last very long.