selecting a client to display his invoices in a month in a calender view

[lec]

Hi,

I have the problem described below that I am trying to find a solution to. 

I have a clients table and a invoice table. The invoice table stores many invoices and a client can have multiple invoices. Two forms are used to populate these two tables.

1st Table : (Personal Details)

Client ID

Date

Name

Email

Phone

Address

2nd Table : (Invoice Details)

Invoice ID

Invoice Date

Client ID

Product

Rate

Amount

 I now wish to use data in 2nd Table to create a calendar view for it. However, I want to be able to first create a form where I can select, from a drop down, the Client ID whose invoice details I want to display in the Calendar view.

The calendar view should show invoices on dates they were generated and once the invoice is selected, another view should display its details of Product Rate and Amount.

Grateful for any help. Thanks.

[Marc_Dillon · Accepted solution]

Build your calendar view on the entire invoice table. Create a LINKTOFILTEREDVIEW action on the client table.

https://help.appsheet.com/en/articles/2357260-linktofilteredview

[lec]

Hi, Thanks for this reply and pointer. Took me quite some time to figure it out but i managed to and it worked. 

Thanks loads.

[lec]

Hi,

Thanks for the response. I'll check and revert.

Thanks again.