CBS

Hi Comment, Thanks for the link to the filemaker page. Do you know of any other links or videos that can explain this in a way that someone who knows basically nothing will understand ?

SO: Set Variable [<variable name> {[<repetition number>]}; Value:<value or formula>] and Set Field [<table::field>; <value or formula>] Does it matter what I call my variable name, does that variable name occur in other areas that I need to choose, or is it just a name you give for this script and serves no purpose other than having some text in front of the coding.... SO in my script which is assigned to my button which I called Create Invoice I have: 1. Set Variable[$Contact ID; Value:Contacts::Con ID#] ----> Contact ID is the made up name for the variable not an field or anything else. Go to Layour ["Invoices"(Contacts)] --> Contacts is the name of my Layout , Con ID# is the auto serial field in my Contacts Layout New Record/Request Set Field [invoices::INV ID#;______________? <--------------- how do I enter the name of the Contact ID I created in set variable ?

Ok thanks I have no idea what a set variable is. I looked in scripts for set variable and not sure what to put in the 3 boxes including the $ info.... Not sure what you mean by #4.

For the last three days I have been trying to understand the Contact -> Invoice starter solution, I have been viewing videos on creating relationships and tables, I have been looking at alternatives such as set field, or lookups... and I have become a bit overwhelmed and confused. I basically want to create a Contact Layout Push a button that says create Invoice and a new record is automatically created in the INvoice Layout with all the choosen Name, address, phone fields etc. The starter Invoice solution in Filemaker 11 has a drop down menu in invoices that has you pick the contacts name.... This I would prefer not to have. If anyone can even point me to a video that shows how to do this instead of trying to re-explain tables, and relationships, and key and primary fields in theory as this is what I cant figure out how to apply. I don't know why I just can;t get it. Help.