So, I'm a relatively new FM user that's designing solutions for my small business. The more I get into this, the more I've realized that I need and want to develop these databases correctly. I've been reading Database Design for Mere Mortals, going through the FM Training Series, and Lynda.com training movies.
I now understand that the solutions I created in the past should have incorporated multiple related tables for the various subjects within the database. So, I'm now working to redesign them by the book to insure they are correct. But, the deeper I get into this the more questions I have with less answers as to why this is really necessary.
One major concern is that I've created my single table databases with nicely formatted layouts for entering/viewing the data (one table, one nice form view layout with tab controls to show relevant fields and list view for quick viewing). I now understand that I'll need to incorporate portals for my new and various new tables to accomplish the same thing. But, these portals will now cause my layouts to look and behave more like scrollable spreadsheets with large, relatively ugly portals all over the place.
So, I'm left wondering do I really need to have a separate table for facility addresses (physical and mailing)? Do I really need another table for facility contacts (primary, secondary, etc)? Do I really need another table for facility equipment details? When it comes to portals, am I stuck with this spreadsheet-like formatting?
I could really use some honest advise on all this...I have a lot to learn and want to get off on the right track. Thanks in advance.