boyblunder

That was it! Once I took the CompanyID out of the relationship it worked perfectly. I'm getting to understand things a little better and you guys have been a great help. Thanks to all of you for your help. Carl

Hi The relationships graph shows the Contacts table and Invoices Table are related “=” by both ContactID and CustomerID”. The layouts are Contacts Entry::Contacts and Invoice Entry::Invoices. The ContactId in the Contacts file also exists as a ContactsID match in the Invoice file. A copy/paste works perfectly if that means anything. This system is built on a separation model but I’m told that makes no difference. I did go to the relationship graph in the Data file to make sure it matched up relationally with Interface file graph and it does. Carl

Hi LaRetta, Ok I changed it so if I’m in my contacts layout and call the script the script is, Get related record from: Invoices Show Record using layout: Invoice Entry Show only related records: is checked Match current record only: is checked Nothing happens. Is there some other part of the script that is needed? Carl

Hi Fitch, I'm on my Contact layout and I set up the "Go To Related Record so it reads. Get related record from: Contacts Show record using layout: The layout I want in the Invoice table is not shown. None of the Invoice layouts are. I have a feeling that's not good! Carl

I have a ContactsID in my Contacts Table and a ContactsID in my Orders Tables. What I want to be able to do is click on a button on my Contacts layout and go that ContactID in my Orders layout. Thank you, Carl

Hi Wplate, I’m using a Mac, FMStudio and Dreamweaver and could sure use your help. I’ve followed the quick stats both in print and in video trying to figure this out but nothing I do makes a difference. I cannot get a connection made to my FMP9A database. I fill in the Connection Name: The name of my solution FileMaker Server: (same one I use for IWP) User Name: Webuser (told to put this in by FMStudio) Password: The one I assigned Webuser Database: I click the Select button and I get "HSTTP Error Code 405 Method Not Allowed." When I click on “Connection Errors Help” I get the following. “405 Method Not Allowed This error is generally caused by IIS servers that cannot properly execute a request to the .php file extension. Common Causes: * PHP not installed on the Testing Server • Testing Server URL Prefix is incorrect and does not point directly into the site folder on the testing server” I know that part of the problem is I don’t understand what the message means as far as my knowing how to fix it and hope you can tell me. Carl

I'm doing some PHP work with Dreamweaver and its telling me to go to my Root Folder. I can't figure out where the Root folder is on a Mac. Can you tell me? It seems I can't do a thing until I figure it out. Carl

Hi Fitch, I didn't find out until yesterday afternoon that along with the CustomerID we also need the CustomerName. Can you show me how to add this to the script so it shows on the Invoice as well? Thanks Fitch, Carl

Hi Fitch, aka “The Poet of Portland”, That did it and I thank you so much for the file. I saw what you did and all of a sodden it clicked. I was reading something on the forum the other day, I think it was on the Cafe, where somebody said they had a quote by their computer that said “To error is human but to really screw up requires a computer”! How true is that? Sometimes you just feel so stupid. Here you are laying the whole thing out for me and I can’t even follow instructions. I sure feel better now and thanks for not just letting me quit Fitch. It was also very considerate to send a file. I’ve heard nothing but good things about this forum and I see why. Thanks for keeping me in the game. Carl

Hi Guys, I never thought of myself as a quitter but maybe I am. I'm asking you guys to spend all this time and I'm getting nowhere. I'm just going to stay with my old Copy & Paste. I'm told time and time again that's not the way to do it any more. But I follow what you guys say and get nowhere. Obviously not your fault, it's mine. Why I can't perform what looks to be the simplest thing in the world I don’t know. All I know is I can't get it to work. The script I have now that will copy my CustomerID from my customer layout and go over to my invoice layout, make a new record and paste it into the CustomerID works without a hitch. That works so I guess that’s what I need to do. All I know is I've wasted enough of everyone's time and it gets a little embarrassing to keep coming back with the same song and dance. Thank you all for your help, but look at this. I have 14 posts and 7 of them are here on the exact same thing. I give up! Carl

Hi Fitch, What in the world is wrong here. Why can't I do what would seem to be the most simple thing in the world? You said: Perform Script [“Create New Invoice” ; Parameter: $id ] I get the Perform Script part, but where do I put the "; Parameter: $id ]" part of it? It looks to me that the scripts I posted under post 267828 are the same you just gave me other than the "; Parameter: $id ]" and as I said I have no idea where that goes. I know you guys want to get rid of me and I don't blame you. I just really need to be able to do this and all I keep doing is going in circles. Carl

Hi Bruce, I'm sorry I don't mean that at all. We will have a new invoice for every customer new order. What I really meant is I do not want a new Invoices assigned if a customer clicks this specific button again. But I've handled that by setting up another layout without the button. So what I’m after is just the ability to click on a button in the CustomerTO customer layout, capture the CustomerID, go to the InvoiceTO Invoice layout and have a new record created with this CustomerID. Can you help me with this? Carl

Hi Fitch, Maybe the best thing for me to do is show you the two scripts. This button is on my customer layout. NEW script Set Variable ($id;CustomerID) Perform Script [“Create New Invoice”] CREATE NEW INVOICE script Go to Layout [“Invoice” (Invoices)] New Record/Request Set Field [invoices::CustomerID; Get (ScriptParameter)] Select Window [Current Window] With these scripts I go to the invoice layout and a new record is created. But the Customer ID is not created with it. I still want what I said from my first post. [color:blue]"One other thing that is important is if this button is ever clicked again for a current CustomerID that it “does not” go to the Invoice file and make another Invoice number. If the CustomerID is already in the system, we would like the button to return them to the Home page." But was unable to get that working either. What have I done wrong? Carl

Hi Comment, I tried the calculation you recommended from the above link and could not get them working. I tried a summary field clicking on the Voting field and clicked on “Total of” but nothing showed in the field. I then changed it to a calculation field “Sum ( Line_Items::Vote )” set as a number and that does not work either. Can you think of anything else I can try? I'm sorry but I don't know what this means. I know i've read something about self-join but i'm unsure what it is. Carl

Hi, Right now we have around 75 products and these are available to all customer and they can vote on any they choose. I went to the link you provided but it confused me. I’m not sure I understand the products file part of it or how the calculations would work on that basis. The Line_Items portal is in my Order Entry file but all of the information to be voted on is in the Line_Items portal. I’m not sure why I’d need to go into a products layout for the calculations to work, but I can add a vote field to my inventory/product file if you need me to do so. Thank you for answering my post. Carl

I have an Order file with a portal called “Line_Items” and in this line items file I have a field called “Vote”. This is where a customer votes Yes or No on a given line item. After a customer votes I need some calculations. • The total number of customers who voted on this product. • The total number who voted “Yes”. • The total number who voted “No”. • The total number of people who voted “Yes” by percent. • The total number of people who voted “No” by percent. Like 77% voted Yes and 23% voted No. Something else that is important, if it's even possible, is to only show the voting results after the customer voted Yes or No. If I need to take them to another layout to show the results, that would be doable. I'd rather not do it that way, but What do you think? Thank you, Carl

Hi Fitch, I set up the two scripts and it’s not working. It’s because I did a poor job of explaining. Please let me try again. The customer has already been assigned a new record with a unique CustomerID and has filled out their customer information. I want this new button to go to the Invoice TO layout and create a new Invoice for this customer. That is really the main thing I need is to be able click the button in the customer file and get that customers CustomerID and CustomerName onto an invoice in the Invoice TO. I guess like any other invoicing system. What I was saying before and saying it poorly is that, If this specific customer, call them CustomerID 1234, has already been assigned an invoice in the Invoice TO, DO NOT make them a new Invoice, just go to that customers invoice in the invoice file that they were already assigned. I had said in the earlier post to go to the Home page but that was not correct. BTW each customer is only assigned one invoice number. They will never be assigned another. Once they have been assigned an invoice number the only changes ever made to the invoice is through the Line Items portal on the Invoice. I know that may seem strange, but that’s how things work here. I’m very sorry for my first “Very Poor” information. Carl

Hi Fitch and thanks for the reply, RE: 1. Make a layout in your Customer file that's based on your Invoice. That will make the scripting simpler; otherwise we'd need a script in the Invoice file. I'm sorry but I don't even know what that means about putting a customer file based on your invoice. I thought I could actually go to the invoice file layout and have the customer id and name show there in a new record. I thought I saw this in a database before, but maybe it wasn't Filemaker. And how would I be able to scroll invoices and use a line items portal if i'm in the customer file? I guess I have to go back to the drawing board because I'm really confused now. But I thank you for answering me. Carl

On my new user layout I have 7 fields that must be entered before the user can continue to the next layout. Each field that must be entered has an "*" by them. When the customer clicks the Continue button here’s what I’d like to happen. 1. If all fields are all entered they go to the Customer layout. If not they are unable to go to the next layout and get a message saying something like “the fields have not been entered”. I would like this message to be a calculation field instead of a dialog box as we may use IWP later. 2. I would like some way to show the customers the fields they omitted. I have not idea how to do this and hoped you may have a good way to do it. Thanks very much for your help. I’m fairly new to all of this and look forward to any comments. Carl

I have a unique CustomerID in my Customer file for every customer. What I want to be able to do is have a script button from my customer file that will make a new record in the Invoice file for that customer so the CustomerID and CustomerName will show on the invoice and make that invoice unique for that Customer. One other thing that is important is if this button is ever clicked again for a current CustomerID that it “does not” go to the Invoice file and make another Invoice number. If the CustomerID is already in the system, we would like the button to return them to the Home page. I would sure appreciate your help, Carl

As you can see I'm new to the forum and need a little help. What I want is for a customer to click on the "New Book" button in the Customer file that will take them to the Book (Invoice) file where a new record will be made for this customer. Each customer has a unique "ContactID". Once a customer has been assigned an invoice number, that is the only invoice number they will ever have. From that time on when this customer clicks the "New Book" button, they will go to the same invoice they were first assigned. Do I also add a customer "ContactID" in the Invoice file? The Invoice has a Line Items portal on the layout and this is where all new books will be added. The "InvoiceNbr" is shown in each line item. Will the customer "ContactID" number have to be there as well? You may be wondering why I want to set up an invoice system this way but it's not really for invoicing. It's just the best way I have of explaining it. I have no idea how to write this script and hoped you can help. Thank you, Carl

Hi Everyone, I know how to go to Accounts & Privileges and set up what I want a customer be able to see and do. That works fine when you open the solution as you would with the office server. But how do you set it up when you design a Filemaker web site where you want the person to be able to look around some before signing up. Once they go to the sign up layout and enter a new “UserName” and “Password”. That’s when I want them to be assigned to our “Customer” Accounts and Privileges. I have no idea how to set that up. Again, I know how to set up from Accounts & Privileges. I just can’t figure out how to implement it from within the solution after the “UserName” and “Password” is entered. If you can help me with this and also the procedure for customers to Re-Longin that would really be great. Thank you, Carl

I'm new and know just enough about Filemaker to get myself in real trouble. But here goes. We are designing a Web site run from FileMaker. We have a standard sign up page layout located in our “Customers TO” where the customer set up an account with “User Name and Password and general information. Here is where I need your help. After the customer provides the information. They click on the NEXT button, are automatically assign a CustomerID” and a New Record is made in our Entry layout in our “Selections TO”. This will be the only new record ever provided for this customer in this TO so that every time they come back and enter their User Name and Password they come to this record. SPECIAL NOTE: If the customer comes back later to make changes to their information and presses the NEXT button. We need to make sure that they still go to the Entry layout, but are NOT assigned a new CustomerID and are NOT assigned a new record. I’m not even sure this can be done but I hope you will know of a way to do it. Once they are in the Entry layout they can click on a short product description from our “Product TO” portal (already set up), which allows them to read a full description and see a picture, located in our “Line Items TO” portal (already set up). I’ve really been struggling to figure out how to set up the script to perform the following. 1. When the customer clicks on the NEXT button as mentioned above. I need to get the ContactID into the Entry layout in the “Selection TO” so we know who the customer is. 2. I need to get the Contact ID into the “Line Items TO” so I know the products this customer clicked on. A couple things maybe you should know. All customers see all the same products to select from the “Product TO” portal. New products are entered almost weekly that they will want to come back and see. Did I even come close to giving you an understanding what I’m talking about? I sure hope so but let me know if I can clear anything up. I've re-read it a couple times and it sounds good to me, but keep in mind my user name is BoyBlunder and I did not come by it easily! : Thanks so much, Carl