Jimjmn

Figured it out.

I'm sure that this has been covered but I have looked through the forum and haven't had any luck finding this exact situation explained so bare with me. I have three tables: * COUNTRIES * STATES * DISTRICTS The COUNTRIES tables has an auto serial # as well as a Country field The STATES tables has a auto serial # as well as a drop down list field for COUNTRIES and a State field The DISTRICTS table has a auto serial # as well as a drop down box for Country and a drop down box that sorts the STATES data based on COUNTRY chosen and then has a District field. I am good on the COUNTRY to STATE relationship for the conditional value list but can't seem to figure out the DISTRICT table relationships to make those drop down boxes work properly. I have gotten the Country drop down to work but I'm stuck in getting the drop down value list for STATES to only show States that have a relation to the chosen COUNTRY. I have attached a sample file conditional value list.fp7.zip

I have created a script that pops up a custom dialog box warning the user that they are about to be logged out due to being idle beyond allotted time. I have set up a Install OnTimer script that initiates the custom dialog box warning and if the user hits OK then it resets the Install OnTimer Script and they have bought more time. The problem I'm having is that if the user doesn't hit the OK button and is idle too long the script is paused indefinitely and I can't close the dialog box and thus log-out the user. How might I get around this?

Don't know why but deleting the fields and reinserting them fixed the issue. Who'd a thunk. Oh well, problem solved.

If you mean selecting "Field Control" in the contextual menu and then "Behavior" and then selecting the "Allow field to be entered: In Browse Mode" check box, then the answer is Yes. If this is not what you meant then please do explain. I have looked everywhere to no avail for an answer to this.

I have a DB posted using IWP and for some reason I can't edit the records. When I click on the edit icon in the status bar to the left and switch to edit mode I can select a few fields but not all of them. Whats up? I have various drop down menus and radio buttons and I can't edit any of them. There are some text fields that are editable and some that are not.

I have a database that shows employees and their managers as well as a table that shows accounts and who started the account(or who it belongs to). On the employee's table there are two portals that display all employees that employee manages as well as a portal to display all accounts that belong to them. I have figured out (with the help of this site) how to toggle the displayed data in the portal from just the info related to the current employee record or to display all of the managers and accounts that are in there immediate down-line. What I would like to do is be able to toggle the displayed data from current record data to all records downline. For example if one employee (we'll call him EMP1) had 5 accounts and he managed 10 employees that also had 5 accounts each and also managed 10 employees each with 5 records....the original record's (MR. EMP1) accounts portal could show 5 accounts (if current records related records radio button was chosen) or 105 records shown of their entire down-line. This would continue all the way down-line. Hope this makes sense. One last thing.....Could someone show me how I might accomplish the same thing but with the list() function? I was told this would be cleaner but I'm not very knowledgeable about this function. I have attached the sample file test.fp7.zip

I know of this option but is there no other way?

I have a DB that has a button on a layout that enables the user to lock/unlock a record. I am executing this by having the button change a field call "lock" from 1 to 0 and in custom privileges the user is locked out if the field contains "0." The problem is that I have portals on the same layout and I'm unable to lock them out. How might I go about this? I know that I could lock these fields from the custom privileges but I would also like to be able to lock these fields on their own layout as well.

I wanted to know if there is a way to create a custom dialog box that displays instead of the "Your access privileges do not allow you to perform the action"?

Efen...thanks so very much!!! One more question: Is there a way to add a custom dialog when the end user tries to input on a field that access has not been granted?

I have created a DB with a button on it that changes the state of a field (lock) from 1 to 0 (1 being default). In Custom Record Privileges I set up the edit column to be "limited" so that whenever the field (lock) is not 0 the record is editable. All of this works but where the issue lies is that when I click the button and it changes the field (lock) from 1 to 0 and so forth the access to the record is not immediately changed until I click somewhere else on the layout. Is there a setting that will correct this behavior?

Could you please explain for my why I can't get this example (LockFields.fp7) to work it the global fields aren't present on the LockFields layout? Thanks so much

I have created a DB to record employees and their managers as well as accounts that each employee has opened. I have the relationships in place that will allow for two portals on each employee's record to show the accounts that they started(and are linked to) as well as all the employees that they manage (have them listed as their manager). What I would like to be able to do is have a radio button option to select whether the portal shows all accounts that the employee opened or all accounts that they opened and all that the employees they manage opened. I would also like this option for the managers portal to see down-line hierarchy. I have attached a sample file. test.fp7.zip

You are the man Bruce. Thanks so very much!!!

I will start with a novice apology. I am wanting to create an employee records DB and each employee will have a manager listed. That being said I would like to be able to list all employees that a employee (manager) has under them in a portal (see attached file). I have played with _pk and _fk to no avail. What am I doing wrong? I'm thinking this is easily achieved with a self-join but maybe I need an join table? test.fp7.zip

Here is what I've got thus far. BLD_2.fp7.zip

One last thing. Here is the simplest way I can explain it: Say I have a bunch of employees and each employee has a manager. Each employee could be the manager of multiple employees. Each employee record would have a manager field. I would like to have a portal on each employee's record that shows who there employees are. How might I go about this? The forums linked in the other replies so far have not helped. Thanks

Thanks for the reply Efan. Unfortunately that link didn't answer my question. Let me try to state what I am desiring to do more clearly. I have a personnel database and each of the personnel are attached to someone who has brought them into the company (kind-of like network marketing). I would like to be able to have a portal or file tree structure that shows the lineage or down-line. Hope this helps explain

Please forgive me as I'm rather new to FMP. I am wanting to create a database that would allow contacts to be sorted like a family tree. Kind of like network marketing. Each contact could have multiple contacts(children) underneath them and I would like to be able to show all info for each contact (child) under then in say a portal. Please enlighten me.

I am new to FM and am wanting to produce a report that is sorted by a range between two dates. I have tried to no avail to have maybe a custom dialog box that would gather the dates and them import them into the search field (purchase date) and then search. I know that I can manualy type the dates into the field seperated by "..." but I would rather it be a little more automated. Any ideas?

I have a portal with about 8 fields and I want to be able to sort the columns by clicking one of the 8 column headers. I have tried to make the header a button and use the sort record function to no avail. What am I doing Wrong?

I have 15 or so and I don't see why not

I don't think I expressed exactly what I was trying to do very well. I have many picture fields and I would like to be able to click on the picture (as a button) and have it open a new window with the picture displayed larger. I have created a new layout with a "picture viewer" field and I just need to be able to tell the "picture viewer" field which picture field from the original layout it should display. I have tried the Get(ActiveFieldContents) function to no avail. Any ideas.

How might I go about getting an enlarged version of a picture to popup in a new window when I click on it?