This is Lim here. I have a problem with conceptualising an excel file given by my boss to sort of convert it into a filemaker database. His idea was to create a small application so that we could monitor the cashflow of the company. a cash in and a cash out. My idea was to create a list view where data could be entered in the cash in area and then when it is cash out the user just needs to click on a button and that particular record is placed in the cashed out area.
I am new to filemaker and would like some assistance on this. How do I come up with the best relationship diagram possible so that I can begin the process of building the database?