Need advice about data base creation from excel file!
I'm new to file maker and have been watching the training videos from Lynda .com to try to get me up to speed, though they only have FM 11 tutorials and not FM 12. I'm working with FM12 pro and I'm debating if I should use a large excel file we have been using to start the creation of our data base or should I create one from scratch.
I'm wondering how does one create mulitple tables and do adequate data modeling to ensure that the data base is setup correctly. i'm not sure how that part works if you just import a larger excel file as it seems to put all the data into one table. I'm still trying to wrap my head around ERD diagrams and what not. This data base is to store information about users and accounts and info associated with them.
Please any direction or guidence is apprecited and please let me know if you need any more information