Problem with create relationships in my new model

[June7]

Identyfikator is set as primary key. Why would DokumentID also be set as primary key? DokumentID appears to be a foreign key, just as EmployeeID is a foreign key.

[jaryszek]

Thank you orange, thank you June7.

I corrected this primary key.

orange - i will test my database, of course, i was asking for now if the relational based data model is quite good...

Best Wishes,
Jacek

[orange]

Jacek,
I think you may have misunderstood my recommendation.

Zalecałem utworzenie modelu danych, a następnie przetestowanie tego modelu przy użyciu przykładowych danych i scenariuszy oraz ich dopracowanie, dopóki nie zostaną spełnione wymagania. Zaoszczędzisz czas i będziesz miał plan, z którego możesz zbudować swoją bazę danych.
Nie budujesz domu (fizycznie), a następnie zdecyduj, czy pokoje są prawidłowe.
Zdajesz sobie sprawę, że kiedy powstają nowe samoloty, przed rozpoczęciem produkcji są często prototypy i modele. Sugeruję to samo z projektem bazy danych.

[jaryszek]

Thank you orange,

No i understand your post very well - you don't have to write it in polish

I was testing my database yesterday a lot.

------>

I have a code which is sending emails from query (not implemented here yet but tested before).

Question
Case:
User is sending reminders on 2017-07-20 for Document1 and Employee1 to the client. This date is stored as tbl_Documents.Email_reminder_date.
After one week(2017-07-25) user wants to send another reminder to the same Employee1, same document1 and same client. We have already one date inputed
in Email_reminder_date.

So what now? I think that system should check if already reminder was sent and add new fresh reminder date attached to field tbl_Documents.Email_reminder_date for exactly the same docuement, employee and client....
How to solve this technically? Did you have the same problem ?


Thank you Guys for your help and support,
Best Wishes,
Jacek Antek

[jaryszek]

Hi Guys,

where i can put this lookup table? Do it separate or create somehow relationship ?

Best wishes,
Jacek

[jaryszek]

Hi Guys,

Please help,
Best Wishes,
Jacek Antek

[orange]

Jacek,

Again, relationships and tables are derived from business rules/facts. If you have a clear description of the business, you can develop and test a data model with sample data and scenarios. Getting your tables and relationships designed to support your business is critical to database. If you don't get these designed and tested, or feel you can do this later, you are in for serious headaches, frustration and will be creating "work arounds" for this all too common design flaw.

I can not over-emphasize how important this part is when developing a database to support a business.

If you provide an English description with details, I'm sure you'll get more focused answers.

Good luck.

[jaryszek]

thank you orange very much,

i am working on this constantly , testing, developing and trying to do my best.

I will show the sample soon, maybe my model is good now (maybe? ), but
i will have of course few question.

My boss is chasing me and i will put the sample here as soon as possible

Best Wishes,
Jacek Antek

[jaryszek]

Hi Guys, Hi Gurus

As I promised i would to show you my final version of database which we talked about here.

For all Access' lernerns i would like shortly explain how all these is working:

1. I have front-end for users and back-end with tables.

2. When user is opening the Access in Access Runtime instance - there is login form - thanks to it I know which data i can show for specific users.
Here If user is Administrator automatically data for tables: tbl_Slow_Dokumenty, tbl_slow_spolki and tbl_Reminders_SAP are inputed.
So macro using Delete, Append and Update Queries keeps always new data and refreshes older (data are uploaded from Excel's files - Excel files are upload from QlikView directly from SAP).

3. Next, users can input a lot of documents at once. My tbl_Braki summary table is fullfiled by them using form InputForm.

4. Administrator has the option to additionally send email for specific criteria (you can check the macro and button in project view).
Email is sent as HTML body and macro is creating table within e-mail body.

If you have any suggestions for it, any questions, please feel free to contact me,
I will try to do my best to help you,

Best Wishes,
Jacek Antek