Hi All, I am developing a system to produce, among other things, Quotations and Job Cards in a mixed FMP and iOS environment. One to the problems was the lack of support for autocomplete of drop down lists in iOS which I have tried to get round, with the help of this community, by using a filter from a cartesian join relationship. I now find that when more than one person is creating a quote on a mobile device from the hosted file that you may end up with other peoples input in your QuoteItems table for the quote you were creating. Can any one tell me how to change the relationship ,(design), to stop this.
On a desktop system the flow is:
From the Customer - create Quote - Quotation Table
In the Quotation Table use the portal into QuoteItems to select the Department, Product and Quantity
The lack of support for Drop Down lists in FM Go is creating havoc for me. I want to be able to create a Quote on site at a customer with two particular fields, one is not a problem thanks to Phil Caulkins excellent demo on Auto-Filtering portals, (ProductName), as it is part of the QuoteLines Table the other one however is not, (Dept), and is currently sitting with a few hundred options. Typing in the name, with the probability of getting it wrong, is very time consuming on a phone. part of it is right but the Dept Field is defeating me.
The file is a dogs dinner but it is only meant to test the functions it is not a work file. Go to the Quotations layout
Any assistance would be very much appreciated
I have a form which uses a drop down list to store an ID and an edit box overlay to show the related value chosen. (still baffled that FM hasn't just made that a native option)
The problem I am noticing is that the Edit box only refreshes when one clicks on a blank area on the form. I have drop down lists in other forms that refresh their edit boxes as soon as a value is selected. The difference being that the ones that refresh immediately, the drop down list field is from the table the form is based on, but if the drop down list field is based on a related table it doesn't refresh immediately.
How do I get it to refresh without changing the forms base table reference or clicking on a blank area of the form?
I have just let this behavior go but now the users are getting annoyed by it. I am on FM 11 but I am not sure all the users are.
Thanks for any help or even just let me know if this is something that just is the way it is.
Workaround to Autocomplete drop-down lists when the value list is set to "Also display values from second field"+ "Show values only from second field"By martaegluu
I am new to this forum. I joined because I am pretty new to Filemaker and I have just come through a problem I do not know how to solve.
The Filemaker has, among others, 2 DB tables: Books and Artists. They are both related through a N:M (many to many) relationship.
The user can select an Artist on the Filemaker solution, and then relate a few books to that artist.
The user CAN NOT relate any artist to a previously selected book: this option oes not and will not exist.
I would like to create a drop-down box for Book Title, but store the Book ID. I would like the user to be able to type the first few letters of the book title and have it cycle through the list so they don't have to scroll through 5000 titles.
I have tried Manage Lists with the first field (BookID) stored and only show the second field (Bookitle), but then the auto-complete doesn't work (it doesn't work when the list is set to "Also display values from second field" or "Show values only from second field" or "sort by second filed"). This is so basic, I must be missing something. Could you please help me?
Thank you so much!