Can I create different screen views of tables?
Posted: Fri Jun 01, 2018 1:38 pm
I use FileMaker Pro, but I might need to make 3 data bases available to others, so using Base could be useful. The data bases are simple tables with no relationships. So selecting/searching should be easy. But I have a question due to ignorance of Base:
FileMaker separates layouts (lists, forms etc) from the data base. So I can create a “table” view on the screen that only contains selected fields and scroll through and search that. I can also have a forms “list” view where there are several forms on the screen and I can scroll through and search them easily seeing several at once. Can I create such layouts in Base? Either or both.
A simple example. A data base consists of about 27,000 names, locations, dates (years and months separately because of the source data, which is 18th and 19th century hand-written sales books), number of items etc. I need a display that includes only names and locations. I also need a display that includes only names and another field. Extremely easy to do in FileMaker Pro, but I have no idea how to do it in Base!
FileMaker separates layouts (lists, forms etc) from the data base. So I can create a “table” view on the screen that only contains selected fields and scroll through and search that. I can also have a forms “list” view where there are several forms on the screen and I can scroll through and search them easily seeing several at once. Can I create such layouts in Base? Either or both.
A simple example. A data base consists of about 27,000 names, locations, dates (years and months separately because of the source data, which is 18th and 19th century hand-written sales books), number of items etc. I need a display that includes only names and locations. I also need a display that includes only names and another field. Extremely easy to do in FileMaker Pro, but I have no idea how to do it in Base!