K
Klingrap
I am trying to create an account ledger (a record of fees and payments) for
multiple clients.
I believe I have created the tables and defined the relationships correctly.
The information is as follows:
Table: tblClients
Fields: ClientID, ClientLastName, ClientFistName. . . .
Table: tblClientBilling
Fields: BillingID, ClientID, BillingDate, BillingAmount, BillingType
I have defined a one-to-many relationship between the tables tbleClients and
tblClientBilling using the ClientID.
I want to create form that shows a list of billing transactions for an
individual client and the total amount owing. I also want the form to have a
"data entry" section to allow a user to add additional entries.
I'm stuck. I'm not sure how to define my querry, or how to set up the
subforms, to accomplish my goal. Someone please help.
multiple clients.
I believe I have created the tables and defined the relationships correctly.
The information is as follows:
Table: tblClients
Fields: ClientID, ClientLastName, ClientFistName. . . .
Table: tblClientBilling
Fields: BillingID, ClientID, BillingDate, BillingAmount, BillingType
I have defined a one-to-many relationship between the tables tbleClients and
tblClientBilling using the ClientID.
I want to create form that shows a list of billing transactions for an
individual client and the total amount owing. I also want the form to have a
"data entry" section to allow a user to add additional entries.
I'm stuck. I'm not sure how to define my querry, or how to set up the
subforms, to accomplish my goal. Someone please help.