Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Spidey

  • Rank

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    OS 10.11

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. How to use "allow creation of records"...and "delete related records in this table"...in the edit relationship. I have attached a file, and I know how to use the "allow creation" and "Delete related records" on the right side(Invoicelineitem). When I delete the records, I know it would delete the line items when I check "delete related records" in the invoice lineline items. I don't know how to use the allow creation of records and delete related records on the left side(Invoice) in the edit relationship. Thanks for your help Regards, KC TestRelationship.fmp12
  2. I created a demo file. My question is how to create customer sales total without using ExecuteSQL. Go to the report and click customer report. And you would see my sql statement. Is there a way to do the same thing not using sql? If I export it to iPhone ExecuteSQL may not work....Thanks. KC Customer Sales Report.fmp12
  3. Hi, I created a form which has two different ports. My question is how to print a report data coming from two ports, since they are different. I can only print report from one portals... Many thanks. KC
  4. Hi, I have two table: Invoice and Customer. I like to have the total of all the invoice for a customer between certain date in the Customer portal that show all the customers, but I got a error when I try to debug.. ExecuteSQL("SELECT SUM(I.TotalAmount) FROM Invoice I JOIN Customer C ON I._kf_CustomerID = C.__kp_CustomerID WHERE date(I.InvoiceDate) between date(C.SearchFromDate ) and date(C.SearchToDate )" ; "" ; "" ) I have an error and couldn't figure it out. Thanks... KC
  5. Hi, I am trying to get the cost from a matrix table. My question is that is it ok to use combine ID using other table ID and use it as a link to connect to other table and get the cost from the matrix, instead of using primary key? Like using a combination of foreign id key to make one unique key to connect to other table with the same key to get the data. Is that ok? If it is not conventional, what is a better proposal? Many Thanks. Text Matrix.fmp12
  6. Hi, I have a field to count the number of records between certain date in calculation: ExecuteSQL ( "Select Count(*) FROM Order2 WHERE DueDate BETWEEN WeekStartDate AND WeekEndDate AND Decoration = 'Digital'"; ""; "") It works the first time but it cannot refresh in the field when there are changes. Is there anything I can do to refresh it? Thanks. KC
  7. Hi, I am new to filemaker. I have created a crosstab table and I like to retrieve data from it in another table. For example, in the layout, "RetrieveData", I like to retrieve the activity name "Apple" in March, I like to get the value "24". How I should approach it in the relationship. Many Thanks. Kent CrossTabInputExample.fmp12
  8. Hi, I am totally new in xslt. I have the following xslt and I tried to export as xml. I got an error. "SAXParseException: invalid document structure". Is there a problem in my structure? What's the proper structure? <?xml version='1.0' encoding='UTF-8' ?> <xsl:stylesheet version='1.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform' xmlns:fm="http://www.filemaker.com/fmpdsoresult" exclude-result-prefixes="fm"> <xsl:output version='1.0' encoding='UTF-8' indent='yes' method='xml' /> <xsl:te
  9. Hi, I have a line inside my tab control in filemaker 16. Do you know what it is for? I have trouble figuring it out... Thanks. Kent
  10. Hi, Do I need to pay more to FileMaker for producing runtime solution in Filemaker Advanced 16? Thanks. KC
  11. I use filemaker 11. I like to take each picture file and match it to the filename and insert the picture in a folder. My logic should be as followed: Loop for each picture in a folder, set the variable x as a picture filename. Search x(picture filename) Insert the picture file to the container End I have problem look to set variable and set it as a picture filename from a folder. Can anyone help me to look for the right function or command from filemaker 11. Thanks. KC
  12. Thank you for your reply. I am looking to integrate filemaker and prestashop so I can add, delete, or change items in filemaker to control prestashop. The following link say it can be done. https://www.prestashop.com/forums/topic/32573-managing-prestashop-via-filemaker-pro/ Does anyone know the details of how they integrate together? Thanks. KC
  13. Can all PHP functions and libraries works in Webdirect in filemaker server 11? KC
  14. I was pulling data from the wrong table. It should be ps_product_shop instead of ps_product if I want to search for price. Thanks.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.