WEB: EMAIL: TWITTER: YOUTUBE: A READER ASKS I was reading your “FileMaker Thought Bucket” Blog. I have developed a FMP solution for our 3000 student school district. I am using Filemaker serial number generated primary keys. Sometimes I have used a number field and sometimes a text field. Your Blog says you prefer text fields. Is that a strong preference and what is your logic? Should I go back and change my number fields to text? Filemaker Pro 10 Key download mac lion free ms office 2010 home and student cheap turbotax free edition vs deluxe. Introducing FileMaker WebDirect. FileMaker WebDirect ™ is a FileMaker ® client that enables users to interact with your solutions on the web. You create solutions. I know that primary and foreign keys have to be of the same type to properly match DWAYNE RESPONDS Well, part of the reason is pure muscle memory. I’ve been doing it that way for so long, that it is second nature to me. Here are some of the other reasons I use text values for my primary key fields. 1) When working on client databases and importing their data into the new database, I increment the first alpha character to a new value. So if the next primary key data string would have been D7341, I change it so the next value is E7341. Then when I look at the list view of my primary keys, I can easily see the records that were created after my last update. 2) Number characters can only go from 0 to 9 per character. In a text setup, I can use at least 30 characters per character (I avoid using O, I, L because they can look like 0 or 1). If I make the field case sensitive by changing the way the index of the field is stored, I can have even more unique character options per character position. Among the many uses of the multi-key techniques in FileMaker are calculation of exploded keys to support partial match filtering. For example, if the target key in the related table is a calculation rendering the value of a field in the related table as an exploded array in the form e ex exp expl explo explod explode exploded. None of these reasons are very strong for going to text strings in primary key fields but I still do it nonetheless. = More info about the author and FileMaker in general, contact me at [email protected]. © 2008 - Dwayne Wright - dwaynewright.com The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc. FileMaker Pro 15.0.2.220 Key // Here // FileMaker Pro 2017 includes all of the features of FileMaker Pro plus a set of advanced development and customization tools. Get features to design and develop custom apps faster and easier. Plus, get robust analysis capabilities, powerful diagnostic tools, and much more. If you want to build more powerful and flexible apps for your business, then FileMaker Pro Advanced is for you. Start quickly Choose from a variety of professionally designed Starter Solutions to manage contacts, inventory, projects, invoices, assets, and more. Import existing data Bring your existing data into FileMaker Pro, including.CSV, Tab, XML, ODBC, and Microsoft Excel files.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |