Help

Creating a database
F
ILEMAKER PRO HELP 154
Relationships also make it possible to group your data to resolve complex queries. For example,
relationships can be used to determine current inventory levels, sales projections, and other
tasks where it is necessary to query data across multiple tables. See
Working with related tables
and files.
10. Determine whether you need to share your database with other users, and how they will
access the file.
See Sharing databases on a network.
11. If you’re designing the database for other people to use, show them your paper plan and
ask them to review it and suggest any changes.
12. Consider who will use the database and whether you want to restrict access to it. When you
create the database, assign
access privileges as needed.
See Protecting databases.
13. Decide what layouts you need, and plan a separate layout for each task.
For example, create separate layouts for printing labels or envelopes.
See Creating and managing layouts and reports.
14. Create a form that lists all the files and tables you need and the fields for each table. Also list
the forms and reports you will generate from each table.
15. Create your database.
16. If you’ve designed the database for others to use, ask a few people to test it. Then, fix any
problems they found before you make the database available for everyone to use.
Related topics
Creating a FileMaker Pro file
Defining database tables
About defining database fields
Creating a layout
About protecting databases
About relationships
Customer ID
Address
Phone
Customer Name
Country
Salesperson
Customers table
Products table
Line Items table
Order Date
Customer ID
Order Date
Invoice ID
Invoice ID
Unit Price
Product ID
Qty
Subtotal
Discount
Extended Price
Product Name
Total
Tota l i n St ock
Order Date
Product ID
Unit Price
Product Name
Stock
Category
Invoices table
Region
Region
Salesperson
Discount
Total in Stock