Daryl

I have successfully setup 3 related fields that display value lists based on related content of another field. In other words, the value list of field1 contains all field data, field2 contains only related data from field1 and field3 contains only related data from field2. This works great in browse mode, but not in find mode. I can get field1 to display all field data, but cannot get field2 or field3 to display any value list. Is it possible to set up this type of relationship to work in find mode? If so, how? Regards

Hello Jamie, That is exactly what I'm looking for. I will have to study how your relationships work as well as how your value lists are set up but the result is what I'm looking for. Thanks so much for the help. Daryl

Thanks for the reply Jamie. I don't want a third table in this scenario. I just need the value lists to drill the data down. Daryl

I have two tables, table A with a one to many relationship to table B. Table B has 3 fields per record that describe the item. One field is "Category", the second field is "SubCategory1" and the third field is "SubCategory2". In a layout for Table A I want to build a series of 3 value lists that drill down to the item in table B and report in a portal. The top level value list would populate with the Category data, the second level value list would then populate with filtered data based on the category data. The third value list would populate with filtered data based on the subcategory1 value and thereby showing me the records in a portal that meet all these criteria. I have tried this many different ways and continue to run into a dead end. I cannot be the only one trying to do this between two simple related tables.

Thank you HTH, that works Daryl

How can I capture a field value and use it as criteria in a find script step?

Thanks for the quick reply.

I need a page numbering syntax on a report to report "1 of 10" for the current page of the number of all pages. I have the (## of ) part down, I just don't remember how to get the total pages variable. Thanks

Is there anyway to lock a record? I would like to be able to make a specific record uneditable given a setting in a field. For example: I have a checkbox field called "lock record" set to a boolean value and if it is set to yes, I don't want the rest of the fields on the specific record to be edited. Is this possible? Thanks, Daryl

Wow, a simple question with a simple answer which another user supplied. As you can see, I'm not a frequent poster here so I appologize for asking such a stupid question. By the way, it's working great now! Daryl

Oh, that should work. Thanks for the simple answer. Daryl

Lee, are you asking this because anyone who is an advanced user should know this or what's your point? Daryl

Hi Lee, Thanks for the feedback. However, the search did not reveal anything relevent nor did I find anything on the web links you provided. Also, I'm not sure what you mean by running a loop script. If I could run a loop script, I should be able to run any script, not just a loop. Let me try again and be a little more specific: I have a checkbox field that when checked will return "1" and when not checked is Null. I want to run a script as I click out of the checkbox field to test if the checkbox field is checked or not and then run a script based on that status. Daryl

In FM Pro 6, is it possible to execute a script by exiting a field? I want to test the field data and based on the test, execute a script. Thanks, Daryl

I have an estimate database with a portal of related records from a subitems database. Within that portal I want to display a field that is related to the subitems database and not the estimate database. This is like a relationship to a relationship. Is this possible, and how? Thanks, Daryl

Thanks, way too easy!

I need the simple loop syntax to loop through a found set of records and simply add a few characters to each record until the script reaches the end of the found set, then the loop ends. I just need to control the loop with a counter and I have forgotten how to do it. Help, Daryl

Thanks LaRetta for the answer. Daryl

I need to open up a file that runs a startup script without running the script. I have forgotten how to do this. Thanks, Daryl

How do I format a find request in the same field for two records? Say I want to find record 1000 and 2050. I only want these two in the result. Thanks, Daryl

Lee, I can get the data in a table ok, it just doesn't have the grid lines of a table nor the field titles. I want it all so that it looks just like the table itself. I can make it work by accepting the copy as a metafile graphic but the graphic includes the whole page and not just the table portion. I'm a home builder and I use filemaker to store all the information about each window in the house. I then want to build a table schedule that can be pasted into my paper layouts in my CAD program for reference on a blueprint. I could do this in my old database application very cleanly by copying the view which contained everything. Daryl

Thanks Lee for trying. Your suggestion does paste all the records but they are not formated in a table like they are in FM. I was hoping there was a way to select the table and copy it like I can in Excel. I suppose the next best thing is to export to Excel and select the table there. I now that works. Thanks again, Daryl

Thanks Lee, but in browse mode, only the record that is current is copied. I want the whole table with the column titles and all the found records. I can get it to work from layout view but then the full page is pasted as an image and not just the table. Also, it is an image and not an editable table within the CAD file. I can make this work fine in excel. Does this make any more sence? Daryl

I want to be able to copy a table layout as an OLE object and paste it into a CAD application. It appears I can do that from layout view but the table is converted to an image object and not editable in the CAD application. Is it possible to copy a table view as an OLE object and paste it as an editable object. This would be similar to copying a range of spreadsheet cells and pasting them into the CAD drawing. Thanks, Daryl

I'm trying to create a field to sum a number field for a found set of records less the current record. For example, lets say I have 10 records in a found set and I want a field that will sum 1-9 and not 10. I've tried a calc summing all 10 values minus the value in the tenth record, but I cannot get it to work. The result will go on a form letter. Help anyone?