Matt Malyschko Posted August 20, 2012 Share Posted August 20, 2012 Hi, I feel my problem is quite simple, but I cannot find a solution anywhere! These are the tables I am working with: Orders OrdersLineItems Items The Orders table holds just basic data - OrderID, SuppliedID, Date... while all the actual details are added into the OrdersLineItems (through a portal). In the OrderLineItems table I have an ItemID, which I have set to be a value list coming from the ItemID's in the Items table. This all works fine. What I am looking for is to be able to have the value list to select the ItemID from the Items table, but instead of displaying the actual ID, I want it to display the 'Description' coming from the Items table. I know I can just add the Description field to the portal and it will display it correctly, but I am also looking to be able to edit the field via the description as I'd prefer to not display the ItemId at all... Please help!! :D Link to comment Share on other sites More sharing options...
Ocean West Posted August 20, 2012 Share Posted August 20, 2012 stack your fields put the ID field under the description field make your description field mask the id field - when you want to select from the popup list have a button take you to the ID Field other wise you enter the description field. Link to comment Share on other sites More sharing options...
Matt Malyschko Posted August 20, 2012 Author Share Posted August 20, 2012 stack your fields put the ID field under the description field make your description field mask the id field - when you want to select from the popup list have a button take you to the ID Field other wise you enter the description field. i'm not quite sure what you mean 'make your description field mask the id field'? Link to comment Share on other sites More sharing options...
eos Posted August 20, 2012 Share Posted August 20, 2012 stack your fields put the ID field under the description field make your description field mask the id field - when you want to select from the popup list have a button take you to the ID Field other wise you enter the description field. If Matty uses a popup menu, he can add the description field as second field to the value list and use the option "Show values only from second field". I think what you are describing is the workaround required when using a drop-down list. Link to comment Share on other sites More sharing options...
Matt Malyschko Posted August 20, 2012 Author Share Posted August 20, 2012 If Matty uses a popup menu, he can add the description field as second field to the value list and use the option "Show values only from second field". I think what you are describing is the workaround required when using a drop-down list. Yeh I have this already and in the drop-down list it displays it, but I also want it to display the description after the value has been selected... (instead of the ID) Link to comment Share on other sites More sharing options...
eos Posted August 21, 2012 Share Posted August 21, 2012 Yeh I have this already and in the drop-down list it displays it, but I also want it to display the description after the value has been selected... (instead of the ID) Well, in that case simply implement Stephen's instructions … Should you need some guidance, here's a quick sample: DropDownMasking.fp7.zip Link to comment Share on other sites More sharing options...
comment Posted August 21, 2012 Share Posted August 21, 2012 Why not simply make the description field non-enterable? Link to comment Share on other sites More sharing options...
Newbies Kevin Kurpe Posted August 21, 2012 Newbies Share Posted August 21, 2012 Hello! PART ONE: MODIFY THE VALUE LIST 1. Open the Manage Value List window. (On the menubar, click FILE > MANAGE > VALUE LISTS) 2. Select the value list that you already created. I am assuming that you named it something like 'Products'. (Double click the value list to open it.) IF you haven't already created a value list, go ahead and create one now by clicking the 'New' button, which is located on the bottom left area of the window. 3. Select the "Use values from field" radio button. Then click the 'Specify field' button. 4. This is where the magic happens! Once presented with the "Specify Field for Value List" window, select the "Item" table from the "Use values from first field" drop-down-menu on the left portal. EXPLANATION So, to explain what you're doing here, you're instructing FileMaker which (field) values to use in the value list. 5. Select the "ItemID" field. 6. Click the "Also display values from the second field" checkbox located on the top right side of the window. 7. Select the "Description" field in the right portal. IMPORTANT 8. There is a checkbox near the bottom of the window titled, "Show values only from the second field - check it. Once checked, FileMaker will only display the second field, which in this case is the "Description" field. 9. Click the "OK" button to save the changes to the "Specify Field for Value List". Click the "OK" button to save the changes to the "Edit Value List". Click the "OK" button to save the changes to editing the "Manage Value Lists". PART TWO: MODIFY THE FIELD IN THE PORTAL 1. Enter LAYOUT mode. 2. Open the "Inspector" window. (On the menubar, click VIEW > INSPECTOR) 3. Click the "Data" tab. 4. Select the "ItemID" field in the portal. 5. Locate the "Control style" in the "Field" section. 6. Select "Pop-Up Menu". 7. Enter BROWSE mode. 8. Test and enjoy! I hope that helps! Link to comment Share on other sites More sharing options...
Matt Malyschko Posted August 21, 2012 Author Share Posted August 21, 2012 Kevin, thanks a lot. Making it a pop-up menu, instead of a drop-down list fixed it completely!! Well, in that case simply implement Stephen's instructions … Should you need some guidance, here's a quick sample: I see that this works, and I like how this looks as opposed to the pop-up menu, however, I don't understand how this works. The box is simply an edit box, and is not associated with any value lists or anything. I'm confused Edit: ok I see that it is a script that simply goes to the record. Is it really that simple? I see that you created a value list Items_d... but what does this link to? Link to comment Share on other sites More sharing options...
comment Posted August 21, 2012 Share Posted August 21, 2012 Is it really that simple? No, it's much simpler than that: DropDownCover.fp7.zip Link to comment Share on other sites More sharing options...
Matt Malyschko Posted August 21, 2012 Author Share Posted August 21, 2012 No, it's much simpler than that: DropDownCover.fp7.zip Nice, this is cool! Link to comment Share on other sites More sharing options...
Matt Malyschko Posted August 21, 2012 Author Share Posted August 21, 2012 Nice, this is cool! It's not possible to do it this way while not showing the ID at all? All I want is the description.. Link to comment Share on other sites More sharing options...
comment Posted August 21, 2012 Share Posted August 21, 2012 If you define the value list to 'Show values only from second field' then the ID will not be shown when selecting a value. However, if using a drop-down, the selected ID will be shown when clicking into the field. This is necessary because a drop-down is still editable. If you want to hide the IDs altogether, you must use a pop-up. Link to comment Share on other sites More sharing options...
Matt Malyschko Posted August 22, 2012 Author Share Posted August 22, 2012 If you define the value list to 'Show values only from second field' then the ID will not be shown when selecting a value. However, if using a drop-down, the selected ID will be shown when clicking into the field. This is necessary because a drop-down is still editable. If you want to hide the IDs altogether, you must use a pop-up. Fair enough. Yeh I changed them all to a pop-up menu! Seems the solution was very simple... lol Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4266 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