database - Filemaker Views based on a criteria

Question

Im building a finance database in filemaker, I have got list of all transaction on table A, the headers would be date, expense type, bank name,Payee, Amount and balance (running total). Im trying to build a view which will display transactions to a specific bank. In total I have got three banks and trying to build views for each bank. Each views should have its own transactions along with running balance.

I have tried to create a new layout for each banks and added new save condition, the problem here is, if I apply a search condition, it applies to all views. Im not sure if custom views with specific criteria are possible in Filemaker, kindly advise.

标签： databasefilemaker

Answer 1

你不需要——也不应该——构建任何只为特定银行服务的东西。

您应该有一个银行表，其中每家银行都有唯一的记录（您可以添加任意数量的银行，而无需修改文件架构中的任何内容）。

要显示特定银行的交易，您可以使用位于银行布局上的交易表的门户。或者您可以简单地在 Transactions 表中执行查找。

回答您的问题：Filemaker 没有“过滤”布局。任何布局都能够显示从关联表中找到的任何记录集。并且与同一表项关联的所有布局都将显示完全相同的搜索结果。