However, field changes could lead to data losses and could be avoided. (Global field), client_id_fk, Purchaser would be fields of Purchase details table.ĭepending upon the requirement, we can create or change the field type of tables.įor e.g. The product, qty, price, subtotal, invoice no. Order_id, Purchaser, ClientPurchase_id_fk would be fielded for purchase table. Likewise, client id, client name, client address would be fielded for client table. In case of invoicing application, in the product table, product id, product name and product price, product initial quantity and the current stock would be the fields for the product table. We need to create a table by clicking on Tables tab.Īlso as per our requirements, we would need to create the desired fields and set up a relationship between the tables. This opens up a window with three tabs i.e. We need to go to the File menu, click on Manage and Database. For instance, product, purchase, client and purchase detail etc. We need to create tables as per our requirements. We need to open the software and create a new solution located in the File menu. The latest version available is FileMaker Pro 17.Īdvanced versions provide much more features to develop an application. Multiple developer versions, such as FileMaker Pro 16, are available in the market. We need to install a developer version of FileMaker on our computer. The following are the steps to set up a simple invoicing application in FilmMaker

Amazon filemaker pro 17 advanced