Let's talk about Table View, I'm not a big fan but you may find it useful as I do for quick databases that users don't see, in other words, personal databases. But before we start let's mention the Record Indicator in List View, you'll see it right here, it's kind of hard to see, it's this little black line and as you go from record to record, whether it's clicking on the record or using this Rolodex, you'll see that it changes, that little black line changes. That tells you what record you're currently on, there are other indicators here as well but it's important to know that, that indicates what record you're going to go to on another layout. So I'm on Danielle Bradbury, I switch, I'm on Danielle Bradbury here, I switch to Billy Adlington, I'm on Billy Adlington over here as well. So it's important to keep track and, and keep your eye open for all these little indicators to you. Realize also that users may not see these as well that's why these features here so you can tell what record you're on. So let's switch to Table View, just click on this button right here and it switches right to Table View. Now if you're used to Table View in previous versions of FileMaker, there are some changes that are very obvious right from the beginning. They cleaned up the interface, made it a little bit more sophisticated, probably the most obvious one is right here where you see the indicator for the record. It used to be an arrow but now it's not anymore and the plus sign is a little bit more a subtle change but we'll get into that and you know it's just, it's not as quite as a big and thick a plus sign as before. But there's quite a few other changes, the gridlines have been updated and things like that but really for me, I'm not going to spend a lot of time here because it's really a, a view that's easy to understand and that's the whole point behind it. They've made it very easy to understand, there's not much explanation needed. So let's take a look at what you can do. You can come over here and switch from record to record just like you do in List View and if you switch over to the other view; you'll be on that particular record. So it works a lot the same as List View but here's where it differs. You can come up here and sort by the first name, the last name or the city. What you have to do is simply click on that Menu and choose Sort Ascending, Descending, whatever you want. In fact there's quite a few additional features here, one that is interesting is Chart. So if I choose Sort Ascending, there you go, it sorts Ascending and you see this little indicator pop up there showing you that, that happened. You can also Resize, just like you would in a spreadsheet because Table View is essentially a spreadsheet like view. It's a view that makes it familiar for people coming from Excel into FileMaker. They know they want a database but they're really quite familiar with a spreadsheet already. So you can drag this and make your column bigger or smaller, you can rearrange your columns if you want, whatever you want to do is available just like you would in a spreadsheet, it's very cool. And you can also come in here and click Modify. This feature is pretty cool because it allows users to get into Layout Mode without them getting into Layout Mode. What they can do is they could say, you know what, I don't want to see the Phone Field on my personal view of this database and it is for their personal view. Everybody else can have a different view so that's one of the cool things about Table View, I, I'm still not sold but it's kind of cool. So you bring it back very easily, they can get to that anytime they want. In fact, they can add any field they want and this is one reason I don't like it is they may not know what these fields are, they may not understand them. So we can come in here and say okay, I want to add the State Field and notice it doesn't have a little lock because it's not Layout Mode. That State Field if we come here and look at Layout Mode, well notice the State Field really isn't there yet. And if we go back here and do Modify again, also notice that you can delete the State Field but we can't delete this, that means it's permanently deleted from that. Of course you can uncheck it like that too but it's up to you how you do it but that's kind of a cool little feature I think but again, for me to let people have access to my schema, it just to, they won't always be able to make sense of it, especially my Naming Conventions I use and things like that. So generally not a good idea. But when you're here in Layout Mode, realize you can also go to Layout Setup and you'll see in the View Section that you can say oh well, you know I don't want to have Form View; I want everybody to ever look at this layer in Form View. I generally don't mess with these checkboxes because I hide the Status Toolbar and that's why I prevent people from changing views so I don't have to worry about that. Because it's a lot of work to go to every layout and say this one's only a List View. Well what's most important here is this Properties. So take a little visual snapshot of this in your brain and notice that this is now available in FileMaker 12 by right-clicking or Control Clicking and you'll see Table View, Edit Properties. Notice that the same view comes up, you can change your grids, you can turn them on and off if you want, you can choose your Grid Color, whether it's dashed or dotted or solid. You can include a Header and a Footer, they're not automatic, that's one of the things that, that you can put in there if you want. You can choose to have Resizable Columns or not, Custom Height you know all kinds of additions here, still doesn't make me happy with this view but you may like it. And also realize you can also do a contextual menus from the Field Section as well. There's all kinds of different features, we won't go over every single one of these but realize all these features are in here that you can get to inside of this Contextual Menu and it's a little bit different depending on where you click, where you right-click or Control Click. So what we're going to do is show you how to change schema from Table View. Again I don't really think this is a great idea but it does make creating a database a little faster I will admit. I still think you should do all your schema changes in Manage Database but I'm going to show you how to do it anyhow.
TERMS & CONDITIONS OF USE
BY SUBSCRIBING TO THIS SERVICE, YOU ARE CONSENTING TO BE BOUND BY AND ARE BECOMING A PARTY TO THIS AGREEMENT, THE TERMS AND CONDITIONS OF WHICH SHALL PREVAIL IN GOVERNING YOUR RIGHTS OF USE. BY CLICKING THE "BECOME A MEMBER" BUTTON, THE INDIVIDUAL OR ENTITY LICENSING THE PRODUCT ("YOU") IS CONSENTING TO BE BOUND BY AND IS BECOMING A PARTY TO THIS AGREEMENT. IF LICENSEE DOES NOT AGREE TO ALL OF THE TERMS OF THIS AGREEMENT, THE BUTTON INDICATING "BECOME A MEMBER" MUST NOT BE SELECTED, AND LICENSEE MUST NOT INSTALL OR USE THE SOFTWARE.
"VTC" refers to Virtual Training Company,
"You" refers to the user or subscriber.
"Software" refers to the VTC training content and software.
2. LICENSE: VTC hereby grants to You a worldwide, non-royalty bearing, non-exclusive license to use the Software according to the provisions contained herein and subject to payment of the applicable subscription fees.
3. RESTRICTIONS: You may not do any of the following:
Save the Software to Your hard disk or other storage
medium; permit others to use the Software except as specified by addendum;
modify, reverse engineer, decompile, or disassemble the Software; make
derivative works based on the Software; publish or otherwise disseminate
the Software. VTC, Inc., VTC Online University, and the Virtual Training
Company site is owned and operated by VTC, Inc. as a corporation of
All materials on this site are the property of VTC unless otherwise specified. No material from these pages may be copied, reproduced, republished, downloaded, uploaded, posted, transmitted, or distributed in any way. Modification of the materials or use of the materials for any other purpose is a violation of U.S. copyright law and other proprietary rights. For purposes of this Agreement, the use of any such material on any other web site or networked computer environment is prohibited.
4. FEES: The rights granted under this Agreement
are effective only upon payment of the subscription fees, which are
strictly non-refundable other than as expressly provided herein. The
term "monthly subscription" is defined as any 30 day period.
The term "yearly subscription" is defined as one 365 day
period. A yearly subscription ends on the same numerical date as it
began (example July 28, 2004 to July 28, 2005).
The VTC Online University is access to every VTC training tutorial in our library. You pay a flat fee for access to these titles. You are billed according to your renewal selection below, and can renew monthly, yearly, or in any other increment offered. If you choose to be billed monthly, you will be billed every 30 days for the subscription until you request the subscription be cancelled. Our terms of service state that you must cancel a monthly subscription at least two business days before your renewal date. These two days give us enough time to ensure that you will not be charged again.
5. LIMITED WARRANTY: VTC warrants that the Software, if operated as directed, will substantially achieve the functionality described. VTC does not warrant, however, that Your use of the Software will be uninterrupted or that the operation of the Software will be error-free or secure. In addition, the security mechanisms implemented by the Software have inherent limitations, and You must determine that the Software sufficiently meets Your requirements. VTC also warrants that the media containing the Software, if provided by VTC, is free from defects in material from the date You acquired the Software. VTC's sole liability for any breach of this warranty shall be, in VTC's sole discretion: (i) to replace Your defective media or Software; or (ii) to advise You how to achieve substantially the same functionality with the Software as described; or (iii) if the above remedies are impracticable, to refund the subscription fee You paid for the Software. Only if You inform VTC of Your problem with the Software during the applicable subscription period will VTC be obligated to honor this warranty. VTC will use reasonable commercial efforts to repair, replace, advise, or refund pursuant to the foregoing warranty within thirty (30) days of being so notified. If any modifications are made to the Software by You during the warranty period; if the medium is subjected to accident, abuse, or improper use; or if You violate the terms of this Agreement, then this warranty shall immediately terminate. This warranty shall not apply if the Software is used on or in conjunction with hardware or software other than the unmodified version of hardware and software with which the Software was designed to be used as described.
THIS IS A LIMITED WARRANTY, AND IT IS THE ONLY WARRANTY MADE BY VTC OR ITS SUPPLIERS. VTC MAKES NO OTHER WARRANTIES, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NONINFRINGEMENT OF THIRD PARTIES' RIGHTS. YOU MAY HAVE OTHER STATUTORY RIGHTS. HOWEVER, TO THE FULL EXTENT PERMITTED BY LAW, THE DURATION OF STATUTORILY REQUIRED WARRANTIES, IF ANY, SHALL BE LIMITED TO THE ABOVE LIMITED WARRANTY PERIOD. MOREOVER, IN NO EVENT WILL WARRANTIES PROVIDED BY LAW, IF ANY, APPLY UNLESS THEY ARE REQUIRED TO APPLY BY STATUTE NOTWITHSTANDING THEIR EXCLUSION BY CONTRACT. NO DEALER, AGENT, OR EMPLOYEE OF VTC IS AUTHORIZED TO MAKE ANY MODIFICATIONS, EXTENSIONS, OR ADDITIONS TO THIS LIMITED WARRANTY.
6. PROPRIETARY RIGHTS: VTC reserves all proprietary rights in and to the Software, is protected by copyright and other intellectual property laws and by international treaties. VTC, Inc.
Trademark Notice: VTC, Virtual Training Company,
Inc., The VTC Logo, and VTC Online University, are trademarks of VTC,
Inc. All other company and product names may be trademarks of their
The information contained herein is subject to change without notice. Copyright © 1995 - 2005 VTC, Inc. All rights reserved.
7. TERMINATION: This Agreement shall automatically terminate if You fail to comply with the restrictions described herein. Your obligations to pay outstanding subscription fees shall survive any termination of this Agreement.
8. LIMITATION OF LIABILITY: UNDER NO CIRCUMSTANCES
AND UNDER NO LEGAL THEORY, TORT, CONTRACT, OR OTHERWISE, SHALL VTC
OR ITS SUPPLIERS OR RESELLERS BE LIABLE TO YOU OR ANY OTHER PERSON
FOR ANY INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES OF
ANY CHARACTER, INCLUDING WITHOUT LIMITATION, DAMAGES FOR LOSS OF GOODWILL,
WORK STOPPAGE, COMPUTER FAILURE OR MALFUNCTION, OR ANY AND ALL OTHER
COMMERCIAL DAMAGES OR LOSSES. IN NO EVENT WILL VTC BE LIABLE FOR ANY
DAMAGES IN EXCESS OF THE AMOUNT VTC RECEIVED FROM YOU FOR A LICENSE
TO THE SOFTWARE, EVEN IF VTC SHALL HAVE BEEN INFORMED OF THE POSSIBILITY
DAMAGES, OR FOR ANY CLAIM BY ANY OTHER PARTY. THIS LIMITATION OF LIABILITY SHALL NOT APPLY TO LIABILITY FOR DEATH OR PERSONAL INJURY RESULTING FROM VTC'S NEGLIGENCE TO THE EXTENT APPLICABLE LAW PROHIBITS SUCH LIMITATION. SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF INCIDENTAL OR CONSEQUENTIAL DAMAGES, SO THIS EXCLUSION AND LIMITATION MAY NOT APPLY TO YOU.
9. Links To Other Materials: Linked sites found at the VTC site are not under the control of VTC, and we are not responsible for the content of any linked site or any link contained in a linked site. VTC may change links based solely on our discretion, and we reserve the right to terminate any link or linking program at any time. VTC does not, by linking to sites, endorse companies or products to which it links and reserves the right to note as such on its web pages. If you decide to access any of the third party sites linked to this site, you do this entirely at your own risk.
Forums, and Chat are not always screened by VTC, and we are not responsible for the content of any public or open forum content at the site. VTC may change these public forums based solely on our discretion, and we reserve the right to terminate any forum at any time. VTC does not, by allowing these forums, endorse companies or products which may be mentioned in these forums, and reserves the right to note as such on its web pages. If you decide to access any of the public forums in this site, or linked to this site, you do this entirely at your own risk.
9. GOVERNING LAW & DISPUTE RESOLUTION: This Agreement is governed by Virginia law. All disputes between You and VTC shall be finally resolved through arbitration in Winchester, Virginia. This site is controlled by VTC from its offices within the United States of America. VTC makes no representation that materials in the site are appropriate or available for use in other locations, and access to them from territories where their content is illegal is prohibited. Those who choose to access this site from other locations do so on their own initiative and are responsible for compliance with applicable local laws. You may not use or export the Materials in violation of U.S. export laws and regulations. Any claim relating to the Materials shall be governed by the internal substantive laws of the Commonwealth of Virginia, USA.
VTC may revise these Terms at any time by updating this posting. You should visit this page from time to time to review the then-current Terms because they are binding on you. Certain provisions of these Terms may be superseded by expressly designated legal notices or terms located on particular pages at this Site.
If you have any questions regarding this policy,
or your information specifically,
you may email us at:email@example.com.