Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have three tables
Product:
Id | Product | Purchase Date |
---|---|---|
11 | P1 | 12-01-2013 |
12 | P2 | 14-05-2012 |
13 | P3 | 17-08-2013 |
Supplier:
Id | Product | Invoice Date |
---|---|---|
11 | P1 | 10-10-2006 |
12 | P2 | 15-09-2005 |
13 | P3 | 11-10-2005 |
Sales
Product | Sales | Purchase Date | Company |
---|---|---|---|
P1 | 200 | 20-12-2013 | Abc |
P1 | 100 | 01-02-2014 | Xyz |
P2 | 150 | 12-03-2014 | Pqr |
P3 | 100 | 12-01-2014 | Abc |
now my requirement is to create a single master calendar for all date field. So whenever any date value is selected possible selection is reflected by all three tables. I know the logic to create,I know I need to find the Max date value and Min date value from all three field.But how all three tables will be associated.
Please help me out if anyone has any idea.
Hi,
Create three separate field in mastercalender for each table:
MasterCalender:
load
Date,
Date as Sales.PurchaseDate,
Date as Supplier.InvoiceDate,
Date as Product.PurchaseDate,
..
Now you can associate each table with corresponding field in master calender