OffTheDeepEnd.com

I have a database with two related tables, Processing Systems and Processing Records. My relationship is based off of the processing record status (Complete or Active) and the machine that it is tied to which allows me to determine which system is available. Currently everything is displayed in a nice list with a one row portal view, which works well for an available system view but not for reporting. I need a way to list all records assigned to the system but also show available systems (with a 0 record count). Below is an example: Current Display: (list view with a one row portal) Tower1 John Doe Tower2 Jane Smith Tower3 (Blank - 0 related records) Tower4 John Keller There are three other records assigned to Tower one but due to the one row portal size, you can't view them in the list. I would just increase the portal size but sometimes there can be up to 20 records on a processing system which leads to a lot of wasted space since this report gets printed. What I would like to display: Tower1 John Doe Tower1 Roger Smith Tower1 Brian Whatever Tower1 Running OutofNames Tower2 Jane Smith Tower3 (Blank - 0 related records) Tower4 John Keller It is almost like I would need a dynamic resizing portal or someway to include the systems with 0 related records in a list.

Thanks for the info. I ended using the ExplodedString and ExplodedKey functions. Works Great!

So basically I am trying to display like records in the portal view based off the last name field as the user is keying. For example lets say there are three records in the client information database: John Doe John Doeter John Doeteritz As the user is keying D into the last name field it shows all three but as there are more characters keyed like doet, it would eliminate the first name since it would no longer match. Below is a screen shot of my layout but I can't think how I could create a like match using a relationship with possibly a wildcard. Please let me know if you have any questions and any help is greatly appreciated.

Technically, the grandchild would be different criteria. The client would like a universal search field that will find a string across multiple tables and fields but return the main record. The search would need to include name fields, tasks, notes, emails, projects... Each of these have their own table and I guess I would need one field with all the data stored. That is why I was thinking of the record index. Sorry that I can't post the solution. It is almost complete development wise and contains client information.

Awesome! Now to add a little more complexity to the situation... There is actually seven tables that all related to the main record but could be three or four relations into the the parent record, i.e. Main Record -> Related Contact -> Purchases -> Projects All four of these tables have a uniqueID that ties back to the main record but are based off more specific data in the relationship. How could I search data that deep into the relationship? Also, would it be worthwhile to build a record index table that would have an individual record for every record in the DB with a related calc field containing all data from that record. That is the only way I can think of aggregating all that data to make it searchable.

It's been a while since I have had a FileMaker project and I just can't figure out how this would work... I have two tables, a main contact table and also a related contacts table. Both of them are linked based off of a primary key in the main contact table. I would like to have an all inclusive search that would find a name in the main and or related contacts but return the main regardless. Example: Main Table: Name: John Doe Related Contacts: John Apple Jane Smith Jane Doe The user would either type the search criteria in a dialog or global search field in find mode. Let say they would search for "John Apple", it would return the John Doe main record but if they searched for John Doe, it would also return the main record. My thoughts on the solution would be to create a calculation field on the related records containing the record data from the main and related contact and make that my basis for search but that just seems kind of clunky and wouldn't work if the main contact did not have any related contacts. Any help would be appreciated.

I am creating a db that will take an order import file and translate it from one system to another mail order system. I was able to get all the data into the correct layout but I need to figure out how to make the fields only display the order total on the first set of records... Here is an example... The way it works now: Line# Order# ProductID Price ShipAmt Total 11 12345 CE121 14.95 7.5 52.35 12 12345 CE122 14.95 7.5 52.35 13 12345 CE123 14.95 7.5 52.35 14 12357 CE121 14.95 7.5 52.35 15 12357 CE122 14.95 7.5 52.35 16 12357 CE123 14.95 7.5 52.35 What I need the system to do: Line# Order# ProductID Price ShipAmt Total 11 12345 CE121 14.95 7.5 52.35 12 12345 CE122 14.95 13 12345 CE123 14.95 14 12357 CE121 14.95 7.5 52.35 15 12357 CE122 14.95 16 12357 CE123 14.95 Line #11 and 14 are the only line that should indicate the order total and shipping amount. Unfortunately I cannot even begin to figure out how to get FileMaker to do just that. All records have unique numerical ids but there is usually 50 orders in one file so it needs to judge which line is the first line for a certain order number. Also orders vary as far as number of items per order. Any help is greatly appreciated.

Here is what I need to accomplish... It seems like an easy script but perhaps my brain is just not functioning this morning... Two Tables, One called "Order Import Data" and "Shipping Info" Each record in "Order Import Data" has 5 fields of shipping information that needs to be extracted to the "Shipping Info" table. So the script would need to create the record and then using an order number relationship place the corresponding information into the shipping info table. It seems pretty straight forward but for the life of me, I cannot get it to work correctly. Any ideas would be a huge help. Thanks!

I am not sure if there is a function that would be able to do this but I figured I might have just missed it. I want to do the following: Adress Field: Company Name Address City, State, Zip Change it to individual fields per line: AddrLine1: CompanyName AddrLine2: Address AddrLine3: City, State, Zip Thanks for any help!

Hello, I was curious if anybody has a copy of Filemaker 6 that they would be willing to zip and send to me? I lost my CD and my hard drive crashed yesterday. I have the license just not the program. Please e-mail me if you are able to assist. Thanks! -Austin Colby e-mail: austin at offthedeepend dot com

Does anyone know if there is a way to script an XML import using and HTTP request into FileMaker 6? Our shopping cart support XML requests and it would be a great way to import recent orders. The only thing is that it would need to be scripted so our customer service department could perform the function easily.

Is there a way to copy layouts from FM 5 to FM 7?

Well, I bought a VLA from filemaker about a year ago and finally decided to take a look at the migration from FM 5 to FM 7. I would like to combine tables into one DB but I do not want to type in all the fields and scripts. Has anybody made a third party solution for that yet that can be used without developer? I really would love to have the functionality of 7 without redoing all of our databases.

I cannot say that I am too impressed with the list print feature, the invoices are not as nice as they were in FM6. The portals printed perfectly in 6 and now they don't in 7. I guess I don't really understand what I need to do in order for it to print an invoice over 18 items. In this solution, we only print one invoice at a time so that helps some.

So why wouldn't I use a grand trailing summary? It seems like that would cover all the records and give me the correct total. I guess it would be a good thing though for orders that would be over two pages though. I cannot think about how to do that one...