Hefty517

Thanks so much...that did it! I really appreciate your help.

Is anyone able to help on this? Is there more information I need to provide? Thanks in advance!

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 each client throughout the year, I would like the drop-down list for project number to only show the related projects that are still open (won't show complete, canceled, or on-hold projects). Any help would be greatly appreciated.

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.

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[] With this current script, it does create a new record, and it does delete the original record, but it does not copy the information over mentioned in the Set Fields script steps.

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 information over into the new table. It will create a new record, and records the timestamp of deletion, but does not input the order ID, job title, and original due date. Any help on this would be appreciated.

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.

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. However, on the portal, it only shows the first of the four. I have the portal set up to be 20 lines, the relationship is the Record ID number of the original record with the repeating fields. I'm sure it's something easy, but can someone help me get the rest of the portal populated? Thanks!

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!

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 now finding out, that causes tons of issues when trying to pull reports. I would like to create a new table, and write a script that would go existing record by record, pull out the repetitions, and make each line of ad info its own record. Once this is done, I would strip out the repeating fields and replace with a portal using the new table I just created. I'm not sure how I would start this, so any help would be appreciated by this barely functioning newbie.

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 narrow it down to just displaying the creative order IDs with that same Media name, but I would like to instead display the creative order #'s attached to that Insertion number. Any help would be greatly appreciated.

Never mind...I got it...I just had to change it to view as list. Boy, I feel dumb.

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.

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.

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 as many properties I could think of in the template layout to try and figure out what I'm missing, but I am stumped. Any help would be greatly appreciated. Thanks in advance for putting up with this newbie.