FileMaker Database Design Help

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Reply

Join Date: May 2008
Posts: 1
Reputation: MikeAz is an unknown quantity at this point 
Solved Threads: 0
MikeAz MikeAz is offline Offline
Newbie Poster

FileMaker Database Design Help

 
0
  #1
May 8th, 2008
I am quite comfortable with MS Access and have developed a complex relational database for my company. However, we have decided to use FileMaker 9 as our database development software, so I have been asked to re-create this same databse in Filemaker. I am finding it difficult, as the simple design of Filemaker takes a lot of the control away from me (i.e. you do not have to create queries or macros to relate/search information) and I am used to working in an SQL format.

My question, for anyone who is familiar with both software, is should I be approaching the design of a FileMaker database differently than if I were creating an Access database. I'm sure if I explored the software more I would have a better understanding of the features and limits of FileMaker, but I need to create this relatively quickly. I am happy to provide more specific information if anyone would care to respond, but I would just like to know how you would approach a relational database differently in both programs.

Thankyou for your time.

Mike
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 12
Reputation: dwikstrom is an unknown quantity at this point 
Solved Threads: 0
dwikstrom dwikstrom is offline Offline
Newbie Poster

Re: FileMaker Database Design Help

 
0
  #2
Jun 3rd, 2008
There is no problem building a complete developer-controlled environment using FileMaker, though thing certainly are different from Access. In FileMaker, the "default" is to let the user do "a lot", notably query very freely. You can either develop scripted queries as a parallel alternative for user-defined queries (to memorize complex queries), or simply prohibit the user from querying by other means than scripts. I'm taking queries as an example, but the same goes for basically any aspect of a database.

This may of course require you to delve more into the details of FileMaker development, but in the long run, it is definitely worth it!


David Wikström
FileMaker 9 Certified Developer
CamelCase data
FileMaker Business Alliance Member
Vancouver, BC, Canada
<EMAIL SNIPPED>
+1-604.603.2558
<URL SNIPPED>
Last edited by peter_budo; Jun 4th, 2008 at 3:56 am. Reason: Keep It On Site - Do not manually post "fake" signatures in your posts. Instead, you may create a sitewide signature within the user control panel.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC