Search the Community
Showing results for tags 'status'.
Found 3 results
I am wanting to post status updates to Facebook using Filemaker 12. I will need to include authorization as I want to be able to post as multiple users FB accounts. (With the users permission) Thanks in advance
Hi, I have a question, is it possible that when a record has a certain status it cannot be changed annymore. For instance i have records in a database with the status "paied" then the record may not be changed anymore. Thanks, Frans
Hello, I'm having trouble with the initial set up of my relationship. For the most part it is a simple 3 table (one to many...many to one) design with a sort of "line-item" table in the middle. There are two sticking points for me:1) I would like to set up the relationships based on the "status" of the line items and 2) the portal should only show records that belong to the user logged in. I am attaching a picture to show the simple table relationship between my current tables: user, charges, patients. I have set up the privilege set so that the user can only see his/her charges when logged in, so I think I have sticking point 2 taken care of without requiring the relationship to handle it. The problem with sticking point 1 is that I want the "Patients" layout to contain 2 portals, one pulling the charges with a "current" status. I would use table occurence "Patients" for this portal. The second portal would be for showing the charges with status "archived" and would use table occurence Patients 2 (normally I would just use portal filtering to get the results I need, but I am calling the data via PHP and portal filtering doesn't seem to apply while using PHP, so I need to figure out how to do it based on the relationships). How can I incorporate the status of the Charge into the relationships between the patients and their Charges where the Patients table is related to Charges with the corresponding kf_ID_Patients and ChargeStatus = "Current" and at the same time where the Patients 2 table is related to Charges with the corresponding kf_ID_Patients and ChargeStatus = "Archived" ? Currently the patients are simply related to the charges via the Primary to Foreign key relationship, but this allows the portals to "see" all the charge records for each patient. I need them to reflect only the charges dependent on the appropriate status. Thank in advance for your help! I feel so close, yet I can't seem to visualize how to do this!