code_geek

Regarding how to access and modify the "fmw_language.fp7" file in the FileMaker Work Requests app - this had me stumped for a bit, then i found the answer on page 69 of the user's guide. This is all you have to do - first open the "FileMaker Work Requests.fp7" file, then from the FileMaker windows menu, select Show Window then select fmw_Language. The window opens, and whenever that window is on top, you can manage the database and everything else in the file. Hope that helps someone in the future, might save a couple hours of dev time that I wasted LOL.

raybaudi - Thanks a bunch! It took me a while to figure out where you were telling me to actually set the script parameter. I discovered that when I use Button Setup to "Perform Script" and click "Specify", there is an Optional Script Parameter at the bottom. I just typed in a name "BeforePhoto1" (didn't even click Edit), so when I run the script I can call [color:red]Get ( ScriptParameter ) and for that button, it returns "BeforePhoto1". [color:green]Perfect.

[color:blue]I have a portal on a Work Order form. In the portal are containers that will store job-related documents. The container objects are set up as buttons that trigger a script that prompts the user for information about the file. The problem is, since there are multiple containers, I want to use a variable to reference which container field the user has selected. For some reason, it seems that once the container object becomes a button, it can not be "selected" and therefore the Get ( ActiveLayoutObjectName ) or Get ( ActiveFieldName ) returns nothing. Does anyone know if there is a workaround for this, or maybe I am doing something wrong? Thanks!

[color:blue]Thanks John! I appreciate the modification you did to my Stores file, you made it work exactly the way I wanted it to! You made my day, you have no idea. It makes perfect sense now that I'm able to see it done correctly. Btw, that whitepaper is an excellent read. I got halfway thru it last night, I should finish it tonite. Lots of invaluable tips in there, I learned a lot! -shawn

[color:blue]Thanks mr_vodka, that worked... but how do I get only the "Completed" Work Orders to display in a portal? I've racked my brain and tried 100 different things (ok i'm exaggerating) and I just can't figure it out. I've been perusing the Whitepaper you have linked. Good stuff, I'm printing all 101 pages to read tonite - seriously. I hope to learn a few things, I've got to get this done! :cofeebrake:

OK, I thought that I understood table relationships, but I'm still trying to wrap my head around it, and I'm feeling dumber with each failed attempt. I've uploaded a copy of my file, which should help illustrate my problem. I have 3 tables - Customers, Stores, and Work Orders. Each table has a self-joined instance. The ViewCustomers object for viewing a list of customers thru a Portal. The ViewStores object links to a global variable "gCustomerID" in the Customers table so a 2nd portal can show only the stores that belong to a specific customer. That part is working fine, however... I really make a mess of things when I try to link Work Orders to a Store by a "StoreID" field. Like I said, I'm still trying to wrap my head around not only the table relationships, but also the layout design, where the layout table is defined compared to which table the Portal is using along with the individual Portal fields. This is how I want it to work: The user starts at the "Home" layout, selects a customer, then a store. The "Store Details" page opens up, and from there you can see Open Work Orders, and create a New Work Order. The problem is that I'm trying to set up a self-join to the Work Orders table using a global variable "gComplete" so in one tab I can show only Work Orders that are Open, and in the other tab I can show only Work Orders that are Complete. I also don't understand how I can get the Customer Name to show on my "Store Details" layout. I want to somehow pull it from the Customers table without creating a redundant field in the Stores table. In SQL, I would have said something like SELECT Name FROM Customers WHERE CustomerID = variable Can someone tell me how many things I'm doing wrong? I am welcome to any and all criticism, anything that will help me understand what I should be doing. Thanks! Stores.zip

comment, Sorry for my delayed response. I studied your example and I finally get it! Thank you! At first I had difficulty understanding how you used the ViewJobs and AllCustomers relationships as a filter. It also took me a while before I noticed the fields that you inserted into the portals and how the field in the AllCustomers portal was set up as a button, scripted to SetField 'gCustomerID' to 'AllCustomers::CustomerID', which basically tells the relationship object to change the filter to the CustomerID of the selected Customer. So complex, yet so simple! This is exactly what I needed, comment. In fact, I see how you can add another column from the same table just by adding another field to the portal. How cool! So thanks again, I learned several things from your example!

Ok, I've read up a little on portals and I think I get the general idea... So I have two tables, the 1st has all the store name and address info - the 2nd has a field for the name only. I set a 1-to-1 relationship between the tables, and I don't think I need a unique ID yet because I only want to list the stores in the main table, using a script or other function to filter the results - its just for listing whats in the table. I'm having trouble understanding exactly what to do though. I can't even get a record to display in the portal... Can someone give me an example that will at least help me get some data displayed in the portal? I figure if I can get that far, I'll understand what's going on. Can someone help shed a little light on how this works? Thanks everyone!

[color:blue]I need to figure out if its possible to create a Windows Explorer style layout, where I can create a list view of customers on the left-hand side, and write a script so that when a customer in that list is clicked, a list of jobs for the customer is displayed in the main body. Does anyone know if this is possible? I think I can figure out the scripting part, I just can't figure out the layout part...