AnsweredAssumed Answered

House Rental solution

Question asked by AviK on Sep 29, 2014
Latest reply on Oct 25, 2014 by philmodjunk


House Rental solution


I am beginner with filemaker and would like to make a database for house rentals. I have 4 tables: Houses, Customers, Rentals & Expenses.

My problem is how to define the relationships: some of the expenses are specific to certain rental (e.g. and therefore to the relevant house) and some are specific to house (with no connection to specific rental. e.g. city tax).

However, I would like to see all the expenses either in one list or in lists by rentals.

Thanks for helping