The problem is I have a value list that is based on 2 fields from another table, the first field is Order and the second is the Description, but it only populates with the first field which is a number and doesn't make sense. We need the description. I've had this problem before and worked around it, and I wish there was a simple way to solve this. So I made a calculation that concatenates the 2 fields for the value list, and the script trigger sets the field with the description without the number included (the script trigger does other things as well). But I realize not all of the value list is sorted correctly because it's a text field. Maybe a new calculation?
Sorry for being long winded, any ideas on how to resolve this issue would be appreciated.
By Bill Richter
So I am fairly new to this and I am trying to get a inventory database set up. I am working on making the database a that is in 3nf. I am trying to pull information on a drop down menu from different tables. I have attached how they are related below. The input menu does not show me anything from the drop down menu, though there is data there. Do I need to create a desperate table for title data where I store information or am I missing a step to pulling the data from the other table?
By Randy Bennett
Yes, I did say iPhone 5 -
I have a small database i created that has a few portals on different layouts - Everything works fine on my Mac, fine on my iPhone X, even fine on my iPad mini
However, I need it to also work on an old iPhone 5 and the portal data is just blank - nothing. In fact, I really ONLY need it to work on this old iPhone 5 (This particular database will go to a music festival to be used by several other people and I can't give them my iPhone)
I have another layout with different portals that are working on the iPhone 5 - but not this main screen.
I have made sure that all of my fields are small and inside the portal. - So, I am stuck as to why? BTW - It is Filemaker Go 126.96.36.1996 (The latest version that I can install on an iPhone 5)
By cat traveller
on a file accessed via filemaker Go 17, I am using a scripted navigation to move records up and down in a portal that is inside a popover.
This has worked in filemaker 12 like a charm and also works on a filemaker client. The records smoothly move up and down the list.
However in Filemaker Go, the portal follows every move of the script as if it is not aware of the freeze portal.
EG the down button is to move the record one record further down inside the filtered and sorted portal (like so)
This is the script.
- freeze window and go to portal
- go to first line of portal and loop through the portal until I hit the record to move
- go to next line and give the position field the value of my record to be moved
- go to line above and give the position field the value of my record +1
- commit record and refresh portal via an x join
- go to last line of the portal
- go to the line of position of my record to be moved.
Would anyone be aware of this issue or know a workaround to stop the portal from flickering?
Thanks so much
I have a drop down in a portal, how do i filter the drop down box to only display the record relating the record in focus on the active layout where the portal is inserted?
example: I have a customer selected in my customer layout, the customer has several products related to that customer. when I click on the drop down list in the portal, I only want to see the products for that specific customer. The drop down is in the warranty portal, products are saved in the product table with a reference to the customer.
Please could you assist?