I am making a simple cash transaction pls analyse my relationships and help if it can be done better .
I am facing problem in providing single id for transaction details in transaction table i have broken details in to Reciept details and Payment details and made a join table to provide single id to Transaction table ( these tables are broken as each type of tranaction head ie reciept/payment have fixed fields for details)
and i want to fill only those details in transaction based on transction head chosen in Transaction table
I am a newbie so pls help ( am attaching a relationship diag)
I am facing problem in providing single id for transaction details in transaction table i have broken details in to Reciept details and Payment details and made a join table to provide single id to Transaction table ( these tables are broken as each type of tranaction head ie reciept/payment have fixed fields for details)
and i want to fill only those details in transaction based on transction head chosen in Transaction table
I am a newbie so pls help ( am attaching a relationship diag)
Attachments
Last edited:
