2 posts in this topic
I have a table called Employees. These are either Current, Freelance, or No Longer Employed.
I want a list available to select current employees. I have a filed called Currentcalc which is a 1 if the employee status is current. All I want to do is to go to an unrelated table and be able to select current employees from a lost. I simply cannot get my head around how to filter lists. I have tried every possible combination of settings and cannot understand the logic of filtered lists.
This should be so simple but I have now wasted an entire day to it. I cannot find a simple explanation on how this works, anywhere. Can anyone explain to me how drop down lists, based upon a calculation filed work?
By Greg Hains
My client has FMS14 running on a terminal server with about 8 clients using it at any one time from that terminal server. From the reports I am getting back, when they open the solution, they are getting a message that appears to show that the Network Sharing has been enabled. As I understand it, when the solution is hosted on FMS, then the Network Sharing (for peer to peer?) should be disabled, however, even after turning off Network Sharing, it appears to come back again. Why is this? How do I stop it please?
The only problem it seems to be causing is the initial error message when the solution is opened. I access the file remotely (not through the TS) and I don't get that message - I'm also the only Mac client if that makes any difference.
Any ideas would be appreciated. :-)
I have a couple of sequence scripts configured on our FM14 server (under Windows 2008 R2) and for some reason, the system level scripts after the internal FM scripts no longer launch under the identity I specify in the schedule config. They always launch under System and that's causing access problems. The server has been rebooted and I have tried brand new schedules for the tasks but nothing changes. Anyone seen similar behavior and have a solution?
By Wayne Irvine
I have a FileMaker layout with a portal to another table. The relationship shows all unassigned records (related < 1). On each portal row I have a button which runs a script. The idea is that when you press the button the a value from the main record is copied and pasted into a field in the portal row (and as a result the portal record becomes 'assigned' and is removed from the portal.
I have the button running a script and pasting the value from the main record but it is pasting it in the first portal record, not the one whose button was clicked.
Is there a simple way of having the value pasted into the portal record where the button was clicked or do I have to store the record number (or something) and paste back to that record?
Hi I'm running FMS server and have daily and hourly backups. I'm not using cloning and I do verify integrity. Today we ran into a major problem were some data was deleted and I wanted to use a backup and restore the data. I moved the backup file to a local machine (away from the FMS and to my local FMA 14) to check if the data we deleted was stil there. But the whole file is empty?! All backups are empty, zero records. The file size is large enough to assume it should be there but there simply is nothing. 0/0 records shown.
I'm not cloning for sure! I have made a new rule for backup and ran it right away and the data is still gone! So all 99 rolling backups are useless. I need this fixed as this is absolutely unreliable now. We assumes we had plenty backups, when there is actually no backup at all.
ps. Stopping the DB and downloading it results in yellow/red/green icons but I don't see it anywhere. Everything is on Macs and the FMS is running at another location.