realationship failure :-(
My relationship life is a FAILURE!!!
I created 3 forms
Client
--Client Name
Session
--Client Name (lookup to Client Form/Client Name)
--Session Cost
--Amount payed
--Date
Extra payment
--Client Name (lookup to Client Form/Client Name)
--Amount payed
is there any reason why when I make a view of the client form, I shouldn't see the fields of Session and Extra Payment in Column Properties? This is how the documentation says to create a relationship.. I thought this was easy. am I missing something? I'd like to view the total amount payed and due for a client, and for my business.
I created 3 forms
Client
--Client Name
Session
--Client Name (lookup to Client Form/Client Name)
--Session Cost
--Amount payed
--Date
Extra payment
--Client Name (lookup to Client Form/Client Name)
--Amount payed
is there any reason why when I make a view of the client form, I shouldn't see the fields of Session and Extra Payment in Column Properties? This is how the documentation says to create a relationship.. I thought this was easy. am I missing something? I'd like to view the total amount payed and due for a client, and for my business.