Hellofred

Need your advise on this !!

I am writing an app (Personal Expenses Manager). Outline of the app is (Categories Table, Expenses Table, Spending Table, Payments Table)

Categories -- For grouping the expenses under categories

Expenses -- Individual expenses

Spendings -- For recording the payments on each expense. Sometimes there can be multiple payments for each spend on an expense (eg: Rent payment weekly for the same month)

Payments -- For recording every single payment. Sometimes multiple payments for a spend (as above)

I am facing problem in designing a form on the Spendings table where I want to have a section for the Payments table so that when I enter the values in those payments table fields and press "Record Payment" button, an entry gets created in the payments table. Basically I am trying to have form fields from the payments table on the Spendings table ('cuz I don't want to duplicate the fields in the Spendings and Payments tables)

Current Table architecture for spendings table is attached below. I want to shift all the fields below "Payment Details" heading in the Payments table instead of having them in the Spendings table ('cuz those fields are directly related to a payment and it makes more sense to have those fields in the payments table rather than having them in the Spendings table and then duplicate the same fields in Payments table)