Valuelist ve relationship help

[kurucay2000]

Since I don't have enough English, I write with google translation.

In the example that I present in the attachment; I have four tables, namely Homepage, Income, Expense and Cash.

https://yadi.sk/d/LnkUypdQtie-8Q

 

I entered the information for 2015 as an example to the tables.

 

My problems are;

1- When I select a date in the homepage, Income, Expense and Cash information should come according to the date I selected.

2- When I select 2015 ... 2020 or one of the new years to be added;

a- Department No, Name and Surname in Income Form

b- Expense No, Expense Name should come automatically in Expense Form

3- When I choose 2015 ... 2020, the Income and Expense tables should be empty and I should be able to enter values manually.

4- In the Cash section, how can I add the revenue from the previous year by calculating the income and expenses from the previous year.

5- If there are incorrect relations or definitions, I would be very glad if you correct them.

 

Thank you very much for your help.

Edited April 12, 2020 by kurucay2000

[kurucay2000]

Can someone help me?

[Wim Decorte]

It's a big ask for most people to have to download your file, inspect how it is built and then begin to answer your questions.  It's probably better to tackle one problem at a time and add screenshots of what you have, explain what you have tried and explain the results you are seeing vs. the ones you are expecting.  Downloading a file (especially from a russian file-share service) is considered risky by most.  So use screenshots for now and start with problem #1.