Salesman0Gil Posted August 2, 2005 Posted August 2, 2005 Hello! I have a file I am working on. There is more to it, but I'm stuck at this little step. The file has Employees, and regions. I have field that has region, and then based on that a portal that displays the employees of that region. Simple right.. Now I want to be able to select the employee I want, to view there equipment (equipment is not part of this problem) So I think Radio Buttons, in the portal!! The radio buttons are based on the same realtionship that the portal is based on, and has the value from the relate field for the value list. The problem is that when I select a radio buttons, I get every employee. If I use a pop up list or menu it works fine, I get a nice little menu. Why would Radio buttons not display the same data as the the list? I've looked around the best, I could figure out was I needed a Self Join realtionship? What is that?? Is that just a fancy name for a normal realtionship?
SlimJim Posted August 2, 2005 Posted August 2, 2005 Understanding your problem is going to be the first step here and the simplest solution would be for you to post the part of your file that is causing the problem. Please don't take this wrongly but your description of the problem is a little bit vague. Back to the beginning - you want to be able to select an employee and view their equipment. Do you mean by that you would like to go to the related employee record and their equipment will be viewable from there (in a portal or as part of the record) or do you mean that when you select an employee in the record then their equipment shows up in another portal on the same layout? I do not understand the purpose of the radio buttons. Are they there in order to change the relationship? In answer to your final question a self-join is a relationship between two ocurrences of the same table and is often used to gather together all the records which share a common value in a given field.
Søren Dyhr Posted August 2, 2005 Posted August 2, 2005 Well what I came to think of when reading you post was this, not knowing if it comes anywhere near what you had in mind??? Look at the attachment! --sd oneselect.zip
Salesman0Gil Posted August 2, 2005 Author Posted August 2, 2005 Thank you for all your help.. Yes my post was verty vague... Sorry, it can be difficult to describe wha tis happening. Anyway.. I figured it out, I needed to check "Only show related records" in the value list setup. My goal here is to have: 1) One Record that keeps changing (no find or sorts) 2) Click on region to show list of employees 3) Click on Employee to see what equipmen they have 4) To see someone else just click a different radio button. Maybe a portal is not the correct way of doing this...
Salesman0Gil Posted August 2, 2005 Author Posted August 2, 2005 So I got the My Radio Buttons.. But as you probably all ready guessed they do not do what I thought they would. Soren Dyhr; I like your solution.. I will modify mine, to work like yours.
Salesman0Gil Posted August 2, 2005 Author Posted August 2, 2005 As a quick side note.. I love your use of PatternCount.. I never thought of using it that way. Very Cool! :woohoo:
Salesman0Gil Posted August 2, 2005 Author Posted August 2, 2005 Quick Question Soren Dyhr For the Choosen field, which highlights the radio button, I'm having a problem. The calculation works, because I see the person I choose gets a 1, but no one else does. In the portal though it comes across as everyone gets a radio button filled in? Any Ideas?
Salesman0Gil Posted August 2, 2005 Author Posted August 2, 2005 Never mind. I hesitated even writing knowing I would figure it out.... Literally 2 min after I wrote this post I got it.. Thanks
Søren Dyhr Posted August 2, 2005 Posted August 2, 2005 So you managed most of your questions on your own, or do you still have vague spots??? Just returning from a visit to a local fun-fair and forrest resort ...listening to children's exited squealing from the roller coster. --sd
Salesman0Gil Posted August 2, 2005 Author Posted August 2, 2005 All right last quick question Is the file Soren Dyhr attached web compatiable?? I have mine set up and everything works except the the radio button to select the person.
Søren Dyhr Posted August 2, 2005 Posted August 2, 2005 All right last quick question Is the file Soren Dyhr attached web compatiable?? I have mine set up and everything works except the the radio button to select the person. Good question, I would say that invisible button should have more than just a Set Field[ ....I'll give it a go tomorrow!!! ... I back again!! No thats correct that the dropdown list can't be set to fire the required commit to make the name selection portal freshen accordingly. But a tabbed interface could ...provided that the number of regions is limited to a handfull. http://previews.filemakermagazine.com/videos/555/15MinuteTabs_full.mov The scripted swithching of layout freshens the portal and submit a commit step. --sd
Salesman0Gil Posted August 3, 2005 Author Posted August 3, 2005 The video was great!! I changed my Pop Up Menu to be radio buttons, and that works for the web. My problems is more with the Chosen button. It seems that a radio button in a portal, does not work with IWP. The cursor changes to a hand, but you can not click.
Søren Dyhr Posted August 3, 2005 Posted August 3, 2005 It seems that a radio button in a portal, does not work with IWP. The cursor changes to a hand, but you can not click. Thats probably down to a platform issue, since it works in safari on a mac, it might also be that your browser isn't supported by IWP, or you've turned off Java.... --sd
Salesman0Gil Posted August 3, 2005 Author Posted August 3, 2005 Everything JAVA works else where, and I'm using Internet Explorer.
Søren Dyhr Posted August 3, 2005 Posted August 3, 2005 Could it be the spacing between each row, that don't allow the invisible button on top of the radiobutton to be with in the bounderies? --sd
Salesman0Gil Posted August 3, 2005 Author Posted August 3, 2005 Ok I Fixed it. I changed the button to the employee name. Now info is not showing up in the protals. The employee umber changes, all files are shared, and all are shared for IWP, Is there something like screen refreash in filemaker for IWP?
Salesman0Gil Posted August 3, 2005 Author Posted August 3, 2005 As a little test. I just put three fields in to the layout, one for each related file, that has a portal. In FM Pro in works fine and shows what it should. With IWP the fields are blank...
Madwolfie Posted August 31, 2005 Posted August 31, 2005 The file 'oneselect', works fine for me and I had hoped that this thread would help me with my own problem, but not yet ! I have a checkbox on a list view of invoices which toggles a PAID and UNPAID text, which flags the important unpaid invoices in red. These invoices also appear in a portal on the relevant clients details - I would like this same flag (or indeed the colour of the invoice line or 'InvoiceTotal' field text) in the portal to be red when UNPAID - at the moment all the clients invoices change when the checkbox is clicked in the original InvoiceList. I have a relationshipo between Clients and Invoices on a unique ID field. I can't work out the significance of Pattern count either yet. Any simple ideas ?
Salesman0Gil Posted September 22, 2005 Author Posted September 22, 2005 I just came back to this post after a long time, I never get email notices, when ever there is a new post, but anyway. I wanted to share what knowledge I have gained since this post. Related Files, I could never get to work with IWP. Related Tables in the same file though, I got them to work. It seems like a bunch of messing around but it still works. Once I put all the info I wanted to see in the same file, Bingo! everything worked great.
Recommended Posts
This topic is 7002 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now