FileMaker Database Design Help

Expand Post »

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

Similar Threads

Help with contact/mailing list database design... in Database Design
Dynamic websites with FileMaker Pro in MS Access and FileMaker Pro
Python and Kexi in Python

MikeAz

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since May 2008

Permalink

Jun 3rd, 2008

Re: FileMaker Database Design Help

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.

dwikstrom

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

12 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS Access and FileMaker Pro Forum Timeline: Basic Beginner's Question about FileMaker Pro 9 and MS Access

Next Thread in MS Access and FileMaker Pro Forum Timeline: Create a report

DaniWeb Message

Cancel Changes

User Name
Password