Forum Discussion
Multiply fields with a connection
Really appreciate it.
3 tables which I connected through a relationship and the table which you see on the right (salary table) is a new one with no connection yet.
Well let me try to explain it, the column Tarifgruppe is about the job. (12 could be carpenter, 13 could be chef) and column Tarifstufe is the level of experience (e.g. up to 20) and of course there are a lot of people on the list. On the right is the corresponding salary table.
Problem is I have a lot of people and possibilities which job and experience they have and now I want to calculate it for each job and experience.
Ok thank you for explaining can you send some sample data? And can a person id have different jobs?
- 2 seconds ago
Tarifstufe Tarifgruppe difference between two dates 00 12 100 01 21 -150 02 22 200 03 23 -500 04 24 600 Sorry had some days off so just got back. And the table is quite bad but I hope it explains it. I want to multiply the difference in the table above with the corresponding salaray below (e.g. 100*207'513 or -150*55'761).
The Tables are a lot longer and a person can have different jobs.
below Tarifstufe, right Tarifgruppe 12 21 00 207'513 195'638 01 205'924 55'761 02 105'140 66'763 03 90'277 62'812 04 152'042 162'675