dnowlan

I am a Mac User, and where I work we are considering moving to filemaker solutions. Right now we only need to use the Instant Web Publishing in the standard PRO. What I am not sure of is whether to host the database on Mac or Windows. I am a long time mac junky, but the place here is mostly windows. I am not looking for a platform war, but any information concerning the stability and Pros and Cons with the Windows version of publishing. Thank you!

I am trying to determine whether I can support all of our companies needs with FM7 (server) instead of using Microsoft exchange, meeting maker or the like. So any input is appreciated. We need to track several things including, events, inventory, groups, members, assets, resources, provide room scheduling etc. We do not need Microsoft exchanges email capabilities as we are hosted externally and meeting maker is web only. I do not want to have several apps for folks to track all of this. i know many of these items are easily accomplished in FMP, but the calendar aspect escapes me. Any thoughts? Thank you!

I need advice on the best implementation on this scenario: I have a table of teachers, a table of classes, and a table of credentials. The class and credential tables do not contain the teacher name as I do not want it tied to the name making related records. What I want to be able to do is assign classes and credentials in a portal in the teacher info without creating records in the other tables. Basically a value list to choose the credential name and the information from the credential list gets imported, same with classes. Does this make sense? Thank you, it has been sometime since in FMP and any help is appreciated.

Anyone have any insight on this? Very appreciated. Thanks!

Thank you, however, I missed some important info. i need to automate the sort in the portal by scripts and button clicks and it need to be compatible with the web.

I must be blind. But I cannot determine how to sort a portal row outside of the preset sort. I want to be able to sort the data in the portal by the field names. Thoughts?? Thanks!!!

I used FMP utlizing FM server, but that is no longer an option as we are hosting remotely with MySQL. Can I create FMP front end to manage the MySQL data? Version: v6.x Platform: Mac OS X Panther

I am debating on whether to utilize Filemaker to track all of my business accounting or to default to something like quickbooks. I am very Filemaker savvy but not sure of issues that Quickbooks may have an edge on filemaker. For one thing you have the build the database as Quickbooks is ready to go. I am looking for getting the mac version of quickbooks but it is crippled compared to its windows counterpart and frankly have no desire to purchase a Windows machine. What complicates things more is Filemaker, inc. latest offering for a rebate if you buy quickbooks and filemaker. Huh?! Thoughts?? Thanks!!!

can anyone suggest a way to do the following. I need to be able to create "x' number of related records in a portal where x is the total months between 2 dates. Basically i have a date range from 1/1/2002 to 3/1/2002 which equal 3 months (anyone know how to calc that to reach "3") and then create "3" related records starting with January and ending with March. The end result would be that i select employee A in the portal from a value list, FM would then create 3 records with the same employee name which auto incremented months ending on March. does this make sense? Thanks!!!

Has anyonefound an easy way to list all lines of a repeating field across records with in single list

My users have found a bug that when they DELETE (using a button assigned to "delete record") a record it not only deletes the current record but all records and their relationships. I do not have a funky script nor do I believe I have a bad relationship. I cannot duplicate the problem but it has happend twice cuaing severe loss of data. Any thoughts??

I have received help on this but still no go. I will try better to explain the issue: I have 2 databases: Database 1 has a summary page to pull data from the database 1 and other related databases. Database 2 has temp employee data I want to be able to show, in the summary page in database 1, the total dollars spent on the current found project from the temp database. In database 2 I calculate the "record total" in database 2 and basically need to have a field in database 1 that says something like: case(project=databse2::project, sum(linetotal)) When I do this the field is blank. Help!! Thanks!!

I am trying to create a summary sheet with summaries, summing total work hours on a project, in one database pulling information from others. This should be simple but I am missing something. Database 1: Field <Grand Total work hours> Field <Project> Database 2: Field <work hours> Field <Project> Dtabase 1: Field definition of <Grand Total Work hours>: Case(database 1/field <project>=database 2/field <project>, Sum(<workhours>) I have tried summaries and other ways but no go.. Any thoughts?? Thanks!!!

I have a container field with references to quicktimes. I need to turn those references into an actual import into the record. Is there a way to do this. I need to move the datatbase to Filemaker server, but all of the references are screwed up. Thanks!!

Can I use filemaker server to initiate a "send mail" script using outlook on the same machine as itself. The send mail is based on user activity. ie. budget is within 20% send mail to manager.

I have 2 databases: 1) a Project profile(contains project specific information ) and, 2) a budgeting database (tracks all invoices) I need to be able to show dollar totals on the "project profile" database by department. The buget database has a department field to differentiate the records and i have a relationship tied to project total. I cannot seem to get dollars seperated by department. i am lookig for a "Sum If" like command. Thanks!