AnsweredAssumed Answered

Merge Payment and Session Table

Question asked by deliciousapple on Jun 18, 2010
Latest reply on Jun 22, 2010 by philmodjunk

Title

Merge Payment and Session Table

Post

Hello forum,

 

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).   

 

Cheers!

 

Gene

 

FMP Advanced 11

Mac OSX 10.6.4

Outcomes