2 posts in this topic
Relating tables with month and year
I have two tables Claims and Premium
Records on both tables have dates
I want to do an analysis for both tables on monthly and yearly basis with a calculation field
Analysis (Claims::claims + Premium::premium)
my objective is to be able to gather all the records for each month and each year on both tables using that analysis. That is my basic task. There are other fields like Remark, and recommendation but they are based from the result I get from the Analysis. For example, Analysis field is > 120 , Remark shows Excellent..
please how do I achieve this?
FM Relationship Error Message
In my attachment, when I search for "Cutting tools" in the main table. It produces the following message. Is there a way I can get rid of this message. I think I know why because I got my product line through calculation of look up.
"This operation cannot be performed because one or more of the relationships between these tables are invalid. "
It's me again....
I've temporarily gotten around my issues with "required value" fields in SQL data by adding a default value to all blank fields, however I have now found another error.
I have a table of customers (BP_Details) which is retrieved from SQL server view using a DSN.
I then have a local Filemaker table ("BPAddon") which I've linked to the BP_Detials table using a unique customer ID field.
I wish to populate the records in the addon table via the Cusomter layout to supplement the data from SQL.
As there are no records in the addon table I've selected "allow creation of records in this table via this relationship" on the add on table side.
I can browse records fine, however as soon as I add data in a field on the addon table I receive an ODBC error: "You cannot specify scroll locking on a cursor that contains a remote table".
Am I doing something wrong in the relationship?
Thanks for any help!
Script find returns error: 500 regardless of date format
By Eli Walker
I'm running a script that should find a set of records within a specific date range. The date range is contained within a variable '$DateRange' which is then entered from the 'Perform Find' script step. Regardless of how I have the date range formatted, the script returns error 500 after the find. I've entered the date both as '1/22/2012...2/26/2012' or '22/1/2012...26/2/2012' or '1-22-2012...2-26-2012' and nothing seems to work. I've run this find request with the value I see for $DateRange in the data viewer while the script is running manually and it works without issue. It just doesn't work during the script. I've run this sort of find before without any issues... the only thing that has changed is that I've upgraded to FM14 (from 13). Any ideas???
Need through relationship
While creating a database that has Products, Suppliers and Lines I have come across the need to calculate a count of the suppliers from the context of a Products record. My relationship is like so:
My question if I want to pull a lot of information about Supplier is should my portal in the Products record be from Suppliers or from Lines? If the best answer is Lines, could I still have a count of related Suppliers by using the primary key from that table in the portal? Is it a bad idea to use fields from a related tables portal other than its own? Thanks