New instances of a table
I'm a super newbie at filemaker (and databases in general), but I've been programming for a long time.
I'm trying to make an exhibit maintenance checksheet program using an inventory database of all the exhibits in a museum. I have already created the program, but what I really need to do is somehow put this table inside of a "Date" table so then someone can check all the exhibits daily and all of this data is stored so that on any day someone can look at which exhibit is broken.
So in a nutshell, I need to create a new instance of a table whenever a new record is created. A "Table of Tables" If you will. I looked at portals but I'm not sure how that would work. Think of this more like a work order program of sorts.
I'm only asking because I'm incredibly desperate and can't find much info on this in a ton of books I've skimmed through. I can attach pictures if that would be more helpful.