In order to add fields to your database, you must first determine what tables you'll have…and then what fields will describe those tables and then finally, what types of fields each will be.…There are two ways that you can define fields in FileMaker Pro. You can define fields…in quick view, like we are looking at here, but we covered that in the Creating New Database…using a Spreadsheet Format video. So feel free to review that movie for more instruction.…The second and more standard method of defining fields is through the Manage Database dialog…which we get to under File > Manage and Database. In addition to providing a central location…for creating and editing fields in any table, the Manage Database dialog also provides tabs…for working with tables and relationships. So it's a good place to add fields that you…have already listed out so you can do many at once. In this movie, I'm actually going…to add all of the fields to the Invoice and Customer tables, and I am going to use the…types that we discussed in previous movies. But first, before I start defining fields,…
Author
Released
5/29/2012- Comparing flat vs. relational databases
- Creating databases from templates
- Determining what tables you need
- Understanding relationship types
- Defining key fields and creating relationships between tables
- Creating fields
- Using new FileMaker 12 container fields
- Creating, duplicating, editing, and deleting records
- Importing and exporting data
- Managing layouts and layout objects
- Applying new FileMaker 12 themes to layouts
- Finding records and working with found sets
- Building reports and charts
- Authoring calculations
- Creating and triggering scripts
- Working with relationships in scripts, calculations, and charts
Skill Level Beginner
Duration
Views
Related Courses
-
Advanced FileMaker Pro 12
with Cris Ippolite7h 33m Advanced -
Learning FileMaker Go
with Cris Ippolite1h 15m Intermediate
-
Introduction
-
Welcome1m
-
Using the exercise files1m 7s
-
-
1. Getting Started
-
What is a database?2m 49s
-
Exploring the interface8m 10s
-
-
2. Database Creation Essentials
-
Adding tables by importing3m 10s
-
3. Creating Tables
-
4. Creating Relationships
-
Understanding key fields4m 19s
-
5. Working with Fields
-
Defining fields7m 22s
-
6. Working with Container Fields
-
7. Working with Records
-
8. Importing and Exporting
-
Importing data9m 8s
-
Exporting data5m 10s
-
-
9. Creating Layouts
-
Introducing layouts4m 51s
-
-
10. Working with Layouts
-
Understanding layout parts6m 31s
-
Previewing the new Inspector1m 22s
-
11. Formatting Layout Objects
-
Applying Screen Stencils4m 3s
-
Applying gradients2m 25s
-
Understanding object states2m 18s
-
Setting field behaviors3m 58s
-
Using the Tab Control feature11m 17s
-
Setting the tab order5m 1s
-
12. Finding Data
-
Saving find requests5m 55s
-
13. Sorting Data
-
Sorting with one criterion4m 40s
-
Sorting with related fields2m 23s
-
Sorting using buttons4m 31s
-
-
14. Value Lists
-
Introducing control styles5m 40s
-
-
15. Printing and Saving
-
Printing merge letters5m 20s
-
16. Reports
-
Adding charts to reports10m 23s
-
17. Calculation Essentials
-
Introducing calculations2m 46s
-
Using number functions10m 29s
-
Using text functions12m 35s
-
Using get functions5m 26s
-
Using logic functions11m 39s
-
-
18. Script Essentials
-
Creating multi-line scripts8m 39s
-
Using the New Window script step10m 58s
-
Using script parameters4m 28s
-
19. Script Triggers
-
Using object-based triggers10m 49s
-
Using layout-based triggers6m 40s
-
20. Using Relationships
-
Using related fields6m 32s
-
-
Conclusion
-
Goodbye1m 16s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Defining fields