Relational Model

[Anonymous]

Hello Community, 

I have  3 sales table with only month and year,  and 3 budgeted  sales tables with only month and year.  how do I create relationship with the date table. I want to calculate the quarterly sales for each year and compare to the each quarterly sales  

Each  Sales table consists of 

Customer

Item

Month

Year

Budget tables also consists of 

Customer

Item

month

Year

Thanks Community

[OliverO]

Hi

The first thing I would do would be combine the three sales tables into 1 sales table and do the same for budgets.

It should fall into place quite easily after that.  Let us know how you go

Cheers

[Anonymous]

 Herez the model, I made a single sales and budget table,,, lets see if it works !! Do you have anything to say !! I will tell you tomorrow if it works.... Thanks

[Anonymous]

Hello Oliver, When i make a list of year , then i get  extra blank list ??? Have any idea ??

[OliverO]

You need to show us what you mean

[OliverO]

Hi

Can you post an image of the data model?

Cheers

Oliver

[Anonymous]