Quang

That's weird. mysql odbc driver 3.51.14 or 3.51.15 didn't work for me. No data showed up

Found the problem. So far, FM 9 on Windows only works with MySQL ODBC 3.51.16, anything else before that doesn't even show up in FM 9, the latest version 3.51.17 gave me the comma problem mentioned. Thanks

On the Mac, using ActualTechnology's ODBC works great. But on Windows(I'm using 2003 Server), the ODBC driver 3.51.17 is giving me the comma problem. Since my FileMaker is hosted on Windows, I can not use ActualTechnology's odbc. Please help.

After setting System DSN odbc driver, verify MySQL database connection, and see MySQL tables; I went into FileMaker 9 and added ODBC datasource from my newly created MySQL odbc source. When I selected my tables, all of my field name shows up with comma in front of the field name in FileMaker 9. And in browse mode, all of my fields has "[MySQL][ODBC 3.51 Driver][mysqld-5.0.27-standard-log]Unknown column ',anyfieldhere' in 'field list' I guess the reason for the error because of the comma "," somehow created in front of the fieldname when I added the external MySQL odbc. What am I doing wrong? Any help is greatly appreciated

Thanks, The 2nd option gave me what I wanted and was the quickest route. Thanks.

Hi, I'm kind of a newbie to the summary report so I need some help on this matter. I created a summary report that looks like this in preview mode: Shop Revenue ----------------------------------- Glass Shop $100 $200 -------- Total $300 ------------------------------------ Machine Shop $200 $300 -------- Total $500 ------------------------------------ Wood Shop $100 $100 ---------- Total $200 --------------------------------------------- Grand Total $1,000 How do I go about getting each of those "Shop" total into a field? Example: g_Field1_Glass=$300 g_Field2_Machine=$500 g_Field3_Wood=$200

You can not do dynamic Table Occurrences. A layouot only displays 1 table occurrences only. Unless you do a Portal to a self relationship.

Thanks. The reason why I do not want to create 3 layouts is because everytime I make changes to 1 layout. I have to re-apply to the other three. It can get pretty nasty if we have 20 layouts per shop. But we want all 3 shops to utilize 20 layouts only because they are the same, instead of creating 60 layouts for these 3 shops.

Here is my situation: Currently I have 2 files. 1. An interface file with one layout 2. A data file with 3 tables. The tables are: a. Machine shop b. Glass shop c. Electric shop The three shop tables have the same amount of fields, the same field name, and all calculations are the same. The only difference is that they are named differently. In the Interface file, I have created a layout call shop invoice. I have also created a file reference to the Shop data file containing the 3 shop tables so I can display the table in the 1 interface layout of "invoice". How can I dynamically change which table shows up in the invoice layout interface? For example. If I am a user from machine shop priviledge set, than, only the Machine Shop table fields should show up in the Invoice layout. Or if I a user is from a Glass Shop priviledge set, then the Invoice layout shoud pull data from the Glass Shop table, and the same thing with the Electric shop. The question is prretty much how do you dynamically change the "show records from" in the layout setup part of filemaker.