Merge Payment and Session Table
I have a client database that I am creating. The main tables are Session, Payment, and Client. Session is just basically an appointment table.
My question is, I need a way to look at all the sessions and payments for a client. I would like to see this in a list view.
So basically I would like a transaction table. In this way I could show a list of both transactions, (payments and sessions).
FMP Advanced 11
Mac OSX 10.6.4