Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Hefty517

  • Rank
  1. Thanks so much...that did it! I really appreciate your help.
  2. Is anyone able to help on this? Is there more information I need to provide? Thanks in advance!
  3. Hi all, Hoping someone can help me out here. I have a pretty standard "Time Log" table in which the employee can put the client, project number, task, and time. I also have a table for the projects, which contains the project number, client, due dates, status (Open, Complete, Hold, Canceled), information, etc. In the Time Log table, the project number is a drop-down value list, so that once the client is picked, the value list only shows the project numbers related to that particular client, and this works perfectly. However, due to the sheer volume of projects we can have for eac
  4. Sorry I didn't respond sooner to everyone; got stuck in a meeting Friday afternoon. I used the Set Variables script step for the Order ID, which was set as the related field in the TO, and everything worked perfectly! I am just now getting intimate with script steps, and I wasn't aware of the set variable step until you guys mentioned it...seems like that is a handy one I will have to remember for the future! Thanks again for everyone's help.
  5. Here is my script as it currently stands: (Starting from within the record to be deleted in the Active Jobs 2008 table & layout) Go to Layout ["Deleted Jobs 2008" (Deleted Jobs 2008)] New Record/Request Set Field [Deleted Jobs 2008::Job Num; Active Jobs 2008::Order ID] Set Field [Deleted Jobs 2008::Media; Active Jobs 2008::Media] Set Field [Deleted Jobs 2008::Client; Active Jobs 2008::Client] Set Field [Deleted Jobs 2008::Original Due Date; Active Jobs 2008::Material Due Date] Go to Layout ["Active Jobs 2008 Form View"(Active Jobs 2008)] Delete Record/Request[]
  6. I am trying to write a script which, and a record is deleted, it will create a record of it's deletion. The issue is, one of our departments will print a report of all jobs due that week, and if a job is deleted, there is no notification. I have created a very basic table and layout, with the fields of order number, job title, original due date, and date deleted. I have played around with a script, in which when the delete button is pressed on a record, prior to its deletion it will copy the above fields into a new record in the deleted job layout. However, I am having an issue copying the
  7. Ha...never mind, I figured it out, and boy do I feel stupid. My fields were bigger in height than the portal line. Everything works fine now.
  8. So, thanks to the help of Comment, I was able to take the records I had stupidly made with repeating fields, and populated a new table by dividing out the repetitions as separate records. I am back to my original layout, where I am going to strip out the repeating fields and replace with a portal. Of course, I tested the portal before finalizing the layout. However, in the portal, it only shows the first record. So, for example, in the repeating fields, I have 4 repetitions. In the new table I created by copying & importing the records, I have 4 separate records, 1 per repetition. Ho
  9. Thank you so much...I can't believe it's that simple. You have no idea how much better this makes me feel...and I learned my lesson - no repeating fields ever again!
  10. Last year, I created a database using my non-existant Filemaker skills, and committed a cardinal sin...instead of using a portal, I used repeating fields for ordering advertising space. Here is an example of what the record currently looks like: Order ID Client info Media info Run Date (repeater) Ad Size (repeater) Cost (repeater) This would repeat several times, as a lot of space was reserved per media, per month. In other words, if I had ordered 4 ads for the month in The Times, each of those four ads would be repetitions 1-4 for Date, Size, and Cost. As I am
  11. I have two interrelated tables. One contains an insertion ID (auto serial number), and Media Name (user entry text). The other contains a creative order number (auto serial number), Media Name (value list from first table), and Insertion ID (value list from first table). The insertion ID on Table 2 is based on the Media Name relationship, so that the drop-down list will only display insertion IDs created for that specific media, instead of all existing insertion IDs. Back on Table 1, I want to create the same type of conditional value list for the creative order number. I am able to narro
  12. Never mind...I got it...I just had to change it to view as list. Boy, I feel dumb.
  13. I'm sorry...I mis-understood. I could have sworn that I've seen that template add a second line, but you're right...it goes back to the first field. I guess I should re-phrase my question: Is there a way to add a second row? Basically, it would look like a table, but with the layout of the form.
  14. Correct. But I am trying to re-create that layout. I'm trying to figure out what I need to do in my own layout to emulate that feature of the template's "list view" layout.
  15. Hello, I am brand new to Filemaker, and am still learning a lot of the basics. I am currently having an issue with something I am sure is very rudimentary. I have Filemaker version 8.5, and the best way I can describe my issue is this: If you go into Filemaker 8.5 and pick the Business-Finance/Purchase Orders template, and then go to the List View Layout, I am trying to recreate that layout. My issue is, unlike the template, when I reach the last field and hit tab, it does not create a second record on the line below...it goes back and writes over the existing line. I have examined a
  • Create New...

Important Information

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