Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About videopuppy

  • Rank
  1. Soren, Thank for the demo file. I think I see what is going on here, but I can't seem to make any difference in your demo using thelookup field, am I missing something? I'm trying to see how I can take this info and utilize it in my db to call the info I'm trying to retrieve. Thanks Dave P.S. When you refer to "TO" you are referring to a table occurrence correct?
  2. Hello, and thanks for your reply. I might be a little confused with your reply. Are you saying I need to do the Autoenter calc with another TO of the Products or just the Autoenter calc ? How would I get the calc to take the input from the field and find the correct corresponding record and display it's information? Thanks Dave
  3. Hmm, well I do have a field (related field) on the two tables that I'm trying to work between. I have tried this a couple different ways and I think I have tried using an additional TO. I have an ID field in the Products table. I have also tried using an ID field in the Lines table (what the portal uses for it's info) with a lookup to the ID field in the Products table. Seems as though this should be fairly straight forward to accomplish. I really need to finish this part of the database so any help you can give would be GREATLY appreciated! Thanks Dave
  4. Hello, thanks for getting back to me . Yes, I have the standard setup of tables (Products, Line items, Customers, Quotes, Invoices). Can you tell me whether or not this is a relations problem? How I can make the Prod ID (non FMP serialized) field the trigger field to pull all the related data from that related product into the portal? All the tables are related using Primary and Foreign keys. Thanks Dave
  5. Hello, I'm having an issue with a portal that I'm using in my one database. What is happening is I have a portal that is used to display products from another table (invoicing database). The portal pulls all the data fields just fine (e.g. Prod name, color, weight, etc.) when using the PRODUCT SERIAL NUMBER (FMP generated) as the select/trigger field. What I need to happen is all this data to be pulled from the products table using another field instead, I want to use the PRODUCT ID field (not FMP generated) to pull all the products data field information (e.g. Prod name, color, weight, etc.).
  6. All I want the find to do is search a customer table and pull up the customers info. In this scenario there are two tables being used, searching from one to the other. Entering "Find" only seems to search the current table the layout is designed around. I would appreciate any information you can share. BTW.... I have looked on the forum here and also FMP help and can't seem to get it to work. I will probably do this in a portal field too, is there any difference when working with find in a portal? Thanks Dave
  7. What I'm trying to accomplish is this. I have two fields on my customers layout, 1 is a credit limit field and the other is invoice total. I have a script that looks at both to see if the invoices total (billed and not yet paid) is greater than the credit limit and if so it pops up a dialog. I would like for this to run each time a customer is selected (from a pull down menu) for a new quote/invoice. Thanks Dave
  8. Hello, Is there a way to run a script (FMP script) when a field has data entered into it? e.g. A customer is selected (using a KF field related to it's KP field), and when selected a script runs. Thanks Dave
  9. Royce, I will take your advise and try that. Sounds like a good idea to me! Thank you Dave
  10. Hello, I've been trying to figure out how to get my script (which determines whether a customer is within credit limit) to run based on the customer that is presently being selected for a new invoice. Even if it was a separate button that is selected to determine credit limit status, how can I get run determine a certain customer. Right now the way the script works is it always uses the first customer in the customer table, the script seems to work otherwise. Code is below. Any help would be GREATLY appreciated. Thanks Dave Find [Over Credit Limit Invoices] Copy
  11. Find [Over Credit Limit Invoices] Copy Perform Script [ “Allow User Abort” ] Perform Script [ “Set Error Capture” ] Perform Script [ “Last Layout [store]” ] Set Field [ QUOTES::KF_CUST_ID_q; QUOTES::KF_CUST_ID_q ] Perform Find [ Specified Find Requests: Find Records; Criteria: INVOICES::Status: “Billed” ] [ Restore ] Extend Found Set [ Specified Find Requests: Find Records; Criteria: INVOICES::Status: “Cancel” ] [ Restore ] Set Variable [ $CreditLimit; Value:Sum(INVOICES::Price_Grand_Total) ] Set Field [ QUOTES::testfield; $CreditLimit ] #ABOVE FIELD IS JUST USED TO
  12. Hello all, I have this script (code below) that works, but I can't figure out how to get it to run using a customer as the search base. When this script is run I need it to do the script based on the current customer being billed. Thanks Dave
  13. Thanks for answering me. Explanation of what I want the script to do. 1.) Sum the total of all unpaid invoices for a particular client. 2.) Compare that total to a preset credit limit. 3.) If the sum exceeds the credit limit either/both a message is diplayed or the fields on the invoice layout become locked. That's about it. Customer number > Total of all unpaid invoices > compare > message or no message. I think I have most of it figured out, but I'm not sure how to associate this to individual customers. I know I have to do it using a serialized key, b
  14. Hello all, In adding a feature to my db for summing clients outstanding dues to a predefined limit I'm running into a snafu. I would assume that this has to be done using a script. Here is my first attempt, which is probably WAY off! Any help would be cool! THANKS Dave
  15. John, Thank you for taking the time to review my problem. I really appreciate your time! Cheers Dave
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.