Campaign management Product catalog Membership manager Event planner Content library. Case manager Customer surveys Training log Return processing Support contracts. Job tracker Inventory manager Barcode organizer Resource scheduler Equipment maintenance. The power of the platform. FileMaker Pro. FileMaker Cloud.
Create apps on Windows or Mac computers. Run apps on Windows or Mac computers. Create apps in the cloud. Run apps on iPad and iPhone. Runs apps in a web browser. Share apps with a team. Although it's possible for multiple users to make changes in the same shared file at the same time, there are limits to the types of simultaneous changes that are permitted.
The following table describes the types of changes you can and cannot make to shared files. Note One person can edit a value list while another person is using it in Browse or Find mode. Note One person can edit a script while another person is using it. Changing tables, fields, relationships database schema. Note One person can edit a data source while another person is using it. Note One person can create or modify an account or privilege while another person is using it.
Note Access privileges may also restrict the ability of users to change certain elements in a file. For more information, see Protecting databases. Site search Search. Site search Search Menu. If you have a licence, submit an IT request to have FileMaker installed.
The two licence options are: FileMaker Pro Advanced - user licence: specified users can use the software FileMaker Pro Advanced - concurrent connection licence: multiple users can use FileMaker server or a single system. You should purchase licences for the maximum number of users who will be using FileMaker at the same time.
Users who are using a concurrent connection licence do not need to have a user licence. FileMaker databases have evolved over the years. Today they consist of several components, not all of which might be present in every database you use:.
With the exception of tables in other files or databases referenced from a database, all the database elements are stored in a single file that can be moved from place to place.
Before FileMaker 7, no serious distinction was made between database files and tables; this was one way in which FileMaker differed from other relational databases. Beginning with Version 7, FileMaker could handle multiple tables within a single database file. The number of tables that a single database file can contain is essentially limitless.
A table is a collection of data—the records and fields described in the following section. Data in a given table is all in a single logical format. A large part of the power of a relational database such as FileMaker Pro is its capability to relate data in one table to another.
As you might expect, tasks are part of projects, and personnel are assigned to tasks. This is all governed by the design of the database: FileMaker keeps the relationships organized. Tables need not be in the same database file to be related to one another, but it makes sense to combine tables that are closely related in a single database file.
For example, if you have a complex Contact Management database, you might have tables for names, for addresses, and for phone numbers, with all those tables being related to one another to combine the data for a single contact. In FileMaker Pro, every layout is based on a single table, although it can use data from other tables as well. A table stores information about many items with similar data characteristics: many to-do items, many contact items, and so forth.
Each of these items is called a record sometimes data record , or, in relational database parlance, a row.
Each record or row has data elements that are called fields , or, in relational database parlance, columns. Fields for a contact record can include a name, an address, and the like; for a to-do item, fields might contain a due date and the name of the task to be done.
Much of that power comes from two major aspects of a database:. The combination of these two aspects of databases—along with many more—make them more powerful than spreadsheets. Each of these interface elements is described in this section.
In a later section, the Status toolbar and associated menu commands are described. They let you control the user interface itself, switching among layouts, modes, and views as well as navigating through your database. Figure 2. The main part of the window is a layout displaying data from the Assets Starter Solution. The FileMaker Pro user interface provides a Status toolbar at the top of the window. There are two parts to the status toolbar, one above the other.
The main part of the Status toolbar shown in Figure 2. Below it, the narrower Layout bar lets you select layouts and control how to view the data as a form, list, or table. Buttons let you enter Preview mode, show or hide the Formatting bar , or edit the layout.
Most FileMaker Pro databases open to a data-entry layout, such as that shown in Figure 2. Generally, you have access to fields, commonly designated by a field border of some kind, including rounded corners, where you can set the corner radius beginning in FileMaker Pro Fields are usually labeled. FileMaker Pro provides some specialized data-entry tools, such as the calendar shown in Figure 2. FileMaker Pro has specialized data-entry tools.
There are two tabs: Topics and Action Items. Each tab displays its own set of data when it is clicked. This makes for a very efficient use of the screen. Use a tab control to save space.
Developers often provide tooltips that appear when you hover the mouse pointer over a specific layout element.
0コメント