rhakka Posted July 18, 2001 Share Posted July 18, 2001 Here is a design question for you all: how far do you go with separate, related files vs. larger files to simplify relationships? for instance, I'm working on a design helper suite for radiant floor heating systems. This has a ton of parts in it, such as heat loss calculations, pump head calculations, customer information, building information, etc etc etc. Many times I need information specific to the components of the system. Various components that carry their own information are things like Heat sources, tubing types, pump sizes, electronic controller types, heat exchangers, manifolds, fitting types, etc etc etc. Needless to say, this is a big project. Now I could have a separate db for each part type: tubing.fp5, heatexchangers.fp5, etc. The issue with this is making sure that new parts make it into the correct databases: there is a master "inventory" file with general information on all of them, then they have to be in the appropriate "part info" database for the design suite to reference it. I'm looking at about 15-16 files just for parts, plus the others, means I'm looking at a total of somewhere around 30-40 files for the design suite alone. Many of which are very simple, 2-5 field databases that the user will never open directly. The other thing I could do is consolidate them into one larger database and rely on relational pulldowns and such to find the correct records and pull the correct information. This has the downside of having lots of fields for each record that will remain mostly blank, though it would simplify my script writing somewhat for adding parts. Now the purist in me says, make as many files as necessary, that's the "best" way. But the pragmatist in me can see that perhaps a single file would be easier for much of the design. Are their compelling reasons to go in either direction on this? What would you do? I'm confident that the relational capabilities of FMP will be adequate either way. Is this just a matter of personal preference? Link to comment Share on other sites More sharing options...
This topic is 7917 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now