User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 423,414 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,722 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 1017 | Replies: 1
Reply
Join Date: May 2008
Posts: 1
Reputation: MikeAz is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
MikeAz MikeAz is offline Offline
Newbie Poster

FileMaker Database Design Help

  #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
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Nov 2007
Posts: 8
Reputation: dwikstrom is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
dwikstrom dwikstrom is offline Offline
Newbie Poster

Re: FileMaker Database Design Help

  #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 2: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  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb MS Access and FileMaker Pro Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum

All times are GMT -4. The time now is 1:43 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC