mr_vodka

If someone doesn't have one, it shouldn't be too complex to create one. Perhaps you can even use their music catalog starting template and tweak it if they have still include it.

Haha... How about life, my wife, and the baby. 😵 Totally all those fault. 😁

I agree with exactly as Michael said. I have created colored gantt charts using repeating calculation fields for this type of activity. P.S. BTW Hello Michael, it's been a long time my friend.

Here try to take a look at this sample file. remove.zip

Not sure if I am following properly but if you have a portal based on a table occurrence of studies, as long as there is no specific filter or join criteria that would stop it from not displaying in the portal, it should display when adding to the studies table.

Try using Open URL

Yes you can use a dialog box. You can use a global field in the custom dialog so that your users can enter the search criteria. Then in your script, you would search "companyABC" in the related field. You can't search for it directly in the facilitiesIDfk field as that seems to only store the key. So if you haven't already create a relationship from facilitiesIDfk to a table occurrence of your facility table. Then have your script search the facility name in that related table.

I'm having a hard time following overall what you are doing based on your previous posts. Perhaps a sample file would be beneficial. As for a particular order for the DISTINCT, if you have a serial ID and ORDER BY that field then it should sort by the order that the records were created. For example using you example... recID fruit 2 - Strawberry 5 - Blueberry 8 - Banana 9 - Banana 13 - Apple 12 - Apple 16 - Apple ExecuteSQL ( "SELECT DISTINCT fruit FROM yourtable ORDER BY recID"; ""; "" ) should work.

I would start by checking under external data sources, what used to be under Define Relationships in fp5 for all your files. Second, if you have never done a conversion from fp5 to fp7 then I would highly recommend you read the documentation on the differences. https://www.filemaker.com/downloads/documentation/fm8_converting_databases.pdf And perhaps this can help you out as well. https://dbservices.com/articles/upgrading-filemaker-pro-part-1-filemaker-conversion/

What happens if Kim creates 10 on her own, Matt 3, and Bill 5? Does Matt keep getting assiged whenever Rose creates a new quote? IOW is the quote being assigned to whoever has the least in the system to distribute evenly or should it just be distributed evenly only by Rose and indepedent of when the others enter in their own quote.

Topics Merged

Have you tried doing a gpudate and relogging in from the clients?

It is optional. You can uninstall it, though then you would manually need to add the server IP for your clients.

This error can come up with a user is entering a wrong password / user name combo

I do find it kind of strange that the software puts the title as part of the URL instead of just using a post number as previous versions. Perhaps a few of us can try to somehow reconcile the issue working together.