Hi Guys,
I have problem with relationships:
I want to simplify my process desription in order to do it quickly ;-)
My process:
1. I have one correction document which can have multiple dates.
One correction document is for one person.
so i have 1 to many relationships between tbl_korekty and tbl_Daty.
So user when is doing correction for Paul Zielinski and input dates from 01.2015 to 03.2015 input will be:
Paul Zielinski, 01.2015
Paul Zielinski, 02.2015
Paul Zielinski, 03.2015
because of this relationship.
And now each record, each month can have also changed status, and date of changing it by user should be saved in my database.
So i created tbl_Status table which has many dates for one record in tbl_Daty. and status_name within tbl_Status_name is always related to tbl_Status (1 to 1 relationship)
So output table looks like (the last is the status change date )
Paul Zielinski, 01.2015, status1, 17-10-2018
Paul Zielinski, 01.2015, status1, 18-10-2018
Paul Zielinski, 02.2015, status 2, 17-10-2018
Paul Zielinski, 03.2015, status 1, 17-10-2018
it seems ok.
Problem appeared when my client changed his idea for tool.
And now he wants to change status for one person once a time.
So input:
Paul Zielinski, 01.2015, status1, 17-10-2017
Paul Zielinski, 02.2015, status1, 17-10-2017
Paul Zielinski, 03.2015 status1, 17-10-2017
If user chooses to change status from staus1 to status2 the input should be:
Paul Zielinski, 01.2015, status2, 18-10-2017
Paul Zielinski, 02.2015, status2, 18-10-2017
Paul Zielinski, 03.2015 status2, 18-10-2017
How can i create this?
Please ask if you do not uderstand something,
Best Wishes,
Jacek Antek