Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Arny

  • Rank

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Thanks for helping me realize the efficiency of using the match process to include the four fields . . it certainly does indeed remove the necessity of concatenating the fields to ensure a proper match. Your suggestion will make that interaction between the databases much easier . . thanks. The separate tables were created to permit, what I thought, would be the best way to isolate the detail tables from the client user. The intention is to make the solution available over the web using a server solution. The client side would only refer to the Support tables but not be able to access the databases directly. The entire solution consists of three separate segments. Segment 1 The Master database keeps track of every Year, Make, Model and Style of vehicle manufactured in the U.S. since 1898. The tables within the Master database permit me to identify a specific combination of permitted YMMS data. I.E. if I enter 1858, every make that existed in 1958 will be displayed . .no others. When I select one of the displayed makes, only the models built by the maker will be displayed . . no others and when I select one of the models only the styles available for that particular model will be displayed . . no others. This four part selection process will uniquely identify the vehicle in which I'm interested. Segment 2 The support tables are now linked to the master record using the proper relationship setup . . your suggestion makes this much more straightforward and easier. Segment 3: I have a client database that permits the client to have portal access to the Master table and create their own selection of YMMS information. This database also has portal access to all the Support tables so the client can view every Engine option, Interior color option, Exterior color option, Production volumes, Brochure images, Vehicle photographs and Misc information that relate to the selected vehicle.
  2. I purposely created separate databases [not tables within the same database] because there are potentially dozens of records in the Support table that relate to the Master table. Perhaps I didn't explain sufficiently what I need to accomplish [on a 'macro' view perspective], but can't see how the record ID will solve my problem. I'm using the YMMS [Yr, Make, Model, Style] key as the link between the two databases to ensure that my portal will show all of the related records. I do, in fact, have eight [8] Support tables that I use. I'm using the Master table to provide the user with the ability to select a 'year', which will then display all of the 'makes' that were being sold that year, which will the display all of the 'models' that were available for that make that year and finally select a 'style' that displays all of the styles there were available for the model, for that make for that year. All of this information is contained within the Master database using separate tables within the database to populate the portals in the to assist in the Y, M, M, S selections discussed above. After this selection has been made, I then use that YMMS key to provide the link to portal views for each of the eight [8] supporting databases. Several of these supporting databases have over 90,000 records and are still growing. Some of these support tables have over 90 entries that relate to a single YMMS key from the Master database. My problem is that I want to send my Master YMMS key via a script parameter to each of the support tables, which I can then parse through to separate each of the four [4] YMMS values into individual fields within the Support table. That being said, I do appreciate your input.
  3. I have, what I believe to be, a relatively straight forward action I need to solve but can't seem to get my head wrapped around the solution. As an example I have two [2] databases, one call Master the second called Support. I have four unique fields in the Master table named Year, Make, Model, Style as well as a calculated field called YMMS which is constructed as . . Year_Make_Model_Style . . [Ex: 1932_Pierce Arrow_Model 38-C_Coupe Runabout]. I put the delimiters in place so I could hopefully parse them when necessary. My Support table also has these same fields including the calculated YMMS field. What I want to do is execute a script in the Master database that will initiate a script in the Support database and pass the calculated YMMS field as the script parameter. Within the Support script I want to retrieve the script parameter and parse the data received, placing the parameter information into each of the four Year, Make, Model, Style fields, excluding the "_" delimiter. I think I need to approach it this way because FM doesn't let me use the SET script step to populate a calculated field, so . . I figure my best alternative is to populate the source fields that will give me the correct calculated results in the YMMS field of the Source database. Any suggestion would be greatly appreciated. Perhaps there's an easy way to pass multiple fields within the script parameter, each have multiple words [as shown in my example above]
  4. This is probably a very basic, simple task but I have a couple of questions regarding container fields. I currently have a container field in FMP13 that is used to store a PDF document. The field has been optimized to support PDF information. The 1st time I enter a table record and insert a PDF into my container field I can either 'right click' and insert or use the menu bar and 'insert'. If I want to replace the PDF, the only way I can accomplish this is to use the menu bar. I'd like to be able to 'right click' whenever I want to insert a PDF. Is the menu bar my only option for updating my container information? I find no way to 'delete' the contents of my container field. I know I've got to be overlooking an obvious solution, but I sure don't see any way to accomplish this. I've tried setting the container field to be both stored locally as well as externally, always with the same results. Occasionally, when I try to replace a PDF the FileMaker Pgm will abort. When I restart the program it will insert the PDF just fine. At this point in time I'm not sure if it's a FileMaker issue or an issue with my server. If you have any suggestions on how to approach resolving this dilemma I'd appreciate it.
  5. I've got a database with multiple tables and I'm running a script from a window that has focus set to [let's say] table 1 and requesting the creation of a new record in table 2. I've traced the execution of this script in FM Go [using the pause steps] and see that when the 'record create' step is executed, the record in table 2 displays exactly as it should. I then execute the 'commit' statement and all of the fields lose their data values and display the "?". I removed commit' statement and get the same results. Strange Now . . if I exit FM Go and re-enter, this new field is gone [poof ! ! !]. This only happens in FM Go. When I execute the script in FM Pro everything works perfectly. All the script steps are iOS compliant. I'm sure I'm missing something quite simple but at this point don't know where to look. Thanks for any advice.
  6. I have a single database solution that was created on my Mac. I have sent it via email to several associates for use on their iPad. Two of the three work perfectly. The third exhibits an error . . " <File> is damaged and cannot be opened. Use the desktop product's Recover command to recover this file" Is there a setting on an iPad that I can't find that causes this error? It's obvious that the FMGO application is valid and works on other devices. Any help or suggestions would be appreciated.
  7. Arny

    Relationship count

    Thanks . . I'll give it a try. Not used to using the SQL options.
  8. Arny

    Relationship count

    I believe this is a rather straight forward question, but I can't seem to wrap my head around the solution. I have a master table that is linked to 7 related tables. Each of the related tables has 1,000's of records. Many of these records have the same master link. All I want to do is determine how many master records have NO relationship inside the related table. For example . . If my master has 10 records and a related table has 900 records. In the related table lets say that there are 100 records for each of 9 master records. The answer I'm looking for is '9', which is the number of unique links between the master and related table. This information lets me determine that I'm 90% of the way toward populating my related table so I have a match for every master table entry. My master table has ~40,000 records and most of the related tables have between 40,000 and 90,000 records, so trying to do this in any manual method seems a bit time consuming and ultimately not worthwhile. Any suggestions would be welcome
  9. Thank you . . you've made it a perfectly easy solution without all the 'clutter'. Thanks again
  10. I have tables of Years, Manufacturers, Makes, Models, Styles . . collectively over 300,000 records. All of my relationships between these tables is working correctly. All I'm trying to do now is simply put a field on my Layout that In can manage through my 'client' table. That client table gives me the ability to manage my logos and URLs through software control rather than by manually changing these logos and/or URL's manually each time they need to change. I want my solution to be 'data driven' as much as possible. Please help me here . . if I use a portal to link, for example, a manufacturer to a supplier, I only want the portal to display the 'logo' field in the related table. How do I get that portal field [namely the logo] to be treated as a 'button' and go to the respective web-site? I do like your suggestion, but up until now I've only been able to assign a URL to a field through a script and the 'Open URL' command. Are you suggesting that I write a script for the portal field and execute the 'Open URL' command that way? Interesting . . .never thought of that approach. Thanks for helping me
  11. Thanks for getting back to me . . as usual, I 'assumed' that my relationships were intuitively obvious . . . sorry bout that. I have a very simple relationship between the client table and the primary table. I have a unique global field in the primary table for each of the client records [a maximum of 7] and a 1-to-1 relationship between the two tables. My primary table displays a lot of automotive information for the user to review and uses the client table only to populate my primary container field with a logo and attach a URL to the field. I want to provide the user a method to go directly to a client web-site in an easy way to let them 'dig deeper' into the information they're reviewing. For instance, if they're reviewing information about a specific "Chevy Impala" they may want to go to a place like Ecklers [a chevy supply house] and see if they have parts available. Does this explanation help?
  12. Sorry bout the confusion. In essence when I start my application, my startup script checks the 'logo' table I mentioned earlier to see if the client is past their expiration date. If not, I want to load the container field in my primary table with the client logo from the 'logo' table and then establish a clien URL link to that container field so that the user can 'click' on the logo and be shuttled off to the appropriate web site. If they are expired, I want to load the container field in my primary table with my 'default' logo and establish a URL link to a my site. I've been able to easily get the logo populated, but am having problems figuring out how to establish the URL link without manually going to the layout and performing a 'button setup' operation. I'm hoping to automate this process so the system will automatically disable the client logo/url. Hope this explains it a bit better.
  13. I have what appears to be a simple problem, but don't know how to address the solution. To keep it somewhat simple. I have two [2] tables. 1. A primary table that contains a layout that contains a container field. I use this container field to hold an image of a client logo. 2. A logo table that contains the client logo, the client URL and and expiration date for the client. [in actuality, there are multiple container fields and multiple client logos] When I open the primary table, my opening script determines whether the client logo should be displayed or not [based on the expiration date]. Depending on the date, I either display the client logo or a default logo indicating this space is not in use. My question is . . can I perform the equivalent of the "Button Setup" action within my opening script to control what URL is to be used in the container field [either the client or the default]? I know I can solve the issue by creating a 'trigger' script for each of the intended container fields, but would rather have a more elegant solution that is handled during the table opening operation.
  14. The primary database is resident on the iPad [downloaded from email]. all the related db's are located on the FileMaker Server. I tried using several different iterations of the database but continued to have the same problem. Then . . I made changes to the app and had all the db's resident on the server. The problem disappeared after that change. I just couldn't understand why I would get that error when using the app in a 'local' manner on the iPad.
  15. I'm using FMGO 13 and have problems whenever I permit someone to select a field to add text. When the keyboard appears I also display the menu bar that permits moving between records, going to find mode, etc. I've looked at script steps and security settings to resolve the problem but can't find anything that will disable that menu bar. Although not a 'show stopper' it does permit users with the ability to do things I don't want done. Hopefully I've overlooked a simple solution.

Important Information

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