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