Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Gismo12

  • Rank
  • Birthday June 2

Profile Information

  • Industry
  • Gender
  • Location

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Windows 10

FileMaker Partner

  • Certification

Recent Profile Visitors

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

  1. Gismo12

    Insert PDF

    Hi Ocean West, thank you for the reply, could you please explain a bit more on the BaseElements? not sure what it is or how to implement it Would I need to install it on all pc's running file maker or only the one we are doing the development on?
  2. Gismo12

    Insert PDF

    Hi All, I have posted on this topic before but I have not come to a solution. I need to attach a PDF file when on click, goto server location, the client must be able to brows for the file, not a fixed location then insert pdf into container Please could you give me a few guide lines as I have tried quite few few with no results
  3. Gismo12

    Using Layout not available

    Oh okay now I understand. So when I am on a certain layout and I want to open a different layout but go to the same customer, how do I accomplish this? Ah, sorry guys, found the solution. I was trying to open a layout from different tables references
  4. Gismo12

    Using Layout not available

    Hi All, Any proposals for above request? would really appreciate it as I just dont know which way to go from here. My Customer_Aircraft layout is not available when usen the Balance sheet as related record
  5. Gismo12

    Using Layout not available

    Hi, The 2 layouts in question here is the Balance Sheet layout and the Customer_Aircraft layout. Not referring to the aircraft spec or the customer layout. I need to open the balance sheet from the Customer_Aircraft Layout Customer_Aircraft Layout has 2 primary keys, Customer ID which record the customer and the Customer_Aircraft ID which refers to the Aircraft ID. So when I write the script to open the Balance sheet and show records from the Customer_Aircraft layout, this layout is not available in the list to select. It only gives me the option of Balance sheet and balance sheet Re
  6. Hi All, Lets say I have a customer tbl , a product tbl and a transaction tbl If customer 1 owns product 1, 2 and 3 and customer 2 owns product 4, 5 and 6 When in transaction layout which was opened by related customer 1, I want to select the products only related to customer 1. How would I setup my drop down box to only show product 1, 2 and 3 related to customer 1 and then when in customer 2, to only show products 4, 5 and 6. I dont see any type of filtering I could do when setting up the drop down box value list. The products tbl does have a customer ID reference so I recon it should not be that difficult but I might overlook something here. The above is not quite my setup but seems easier to explain my problem.
  7. Gismo12

    Using Layout not available

    Hi, I used the name Customer_Aircraft as I already have a Customer Tbls and an aircraft Tbl which stores specific Aircraft detail. In the Customer_Aircraft TBL I Can Select the Customer and the Aircraft detail so yes you are correct, this is a it is pretty much a join table storing all the aircraft secondary detail per customer. Below is my new relationship with ID's I still can not see my Customer_Aicraft tbl in Show current record using layout when I select Balance sheet as get related record from.
  8. Do you need the actual Customer Id control in the layout to set the variable? I dont want to display the customer id number. on a different topic, when I go to the new customer layout, the customer ID is set to auto. the customer ID does not display. but when I go to edit mode and back to browse mode, the auto Id does display. When I open the new customer layout, enter the customer name, without the display of the customer number, the set variable / set field does not work. if i do go to new customer, edit mode then back to browse mode, the customer id shows and then the set variable / set field works well any suggestions?
  9. It is like a miracle Thank you
  10. Hi, The customer Id in the TBL Customer_Aircraft is not a auto create field. Doesn't set variable copy the Id in the customer tbl and set field past it in the TBL customer_Aircraft ID field? If I dont set the ID in the Customer_Aircraft field, how will I relate to the ID created in the Customer TBL?
  11. Gismo12

    Using Layout not available

    Hi, I am changing all my relationships to a unique key. The registration is a manual field created by the user, not a auto number. it is a text field. But after changing all my tables to relate to a primary key, will i be able to see the table when I select in the list for show record using layout?
  12. Hi All, I have some issues with Set Variable / Set Field. From the Customer TBL - New Customer Layout, I create a new Customer Name. Customer_Id created auto. Script: The New Customer / Aircraft Layout opens from TBL Customer_Aircraft but no Customer Id is set. Please could you tell me where I am going wrong? Relationship is one to many
  13. Gismo12

    Using Layout not available

    Hi, Most of my tables relate to a registration number which must be a text field. I did not select the ID if the aircraft to be my key throughout the DB. and on the layout side, when using the balance sheet as related record, I dont have Customer_Aircraft in the list either. Maybe, my relationship table will give clarity for my reason to Registration as a key. Could this be part of my problem i am having?
  14. Gismo12

    Using Layout not available

    Hi Steve, Here is the attached as requested. I refer to the Customer_Aircraft TBL and the Balance Sheet TBL. Balance Sheet is not in the list to select as "Show record using layout"
  15. Gismo12

    Using Layout not available

    Hi All, I have 2 related table. when in layout 1, i need to go to related record in layout 2 When I write the script, I select layout 1, but table 2 is not in the list when selecting show record using layout. any suggestions?

Important Information

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