As a beginner you first need to tell us about the business context - what is the database for, how you expect to use it in your work. The start and fundamentals for your database are to understand the scope and business requirements to then define a database schema on which you can build the application. As it is written using a language that is not English - it is difficult to interpret. If your tables are well-formed, you are not enforcing referential integrity in any of the relationships. That is about the rules that determine such things as what record must exist before a record in a child table can be added, or when deleting a record do you want the child records to also be deleted, or will they be orphaned. Cannot tell if valid but KOMB_ID in KombiT relates correctly to Vakcin_veids. But difficult to move further without more explanation of your business.
Language" Latvian, seems to be about vaccinations?
Thank you for your time and advice!
I will try to explain so everyone could understand better. Language is used Latvian but no apostrophes used in names as VBA, table names an such on.
this is small business - vet clinic.
database purpose is to collect data about simple things as - client info, visits, vaccinations and some medications used in visits. some forms just show aftermath about vaccinations and medicine so i can faster fill some forms in real life.
PamatsF is main form. there you can go to clients card (klienta kartinas) and after that to visit card where is smal subform with history, and main subform to fill visits card. and main visits form is basicly clients small info (usefull at work, so i dont have to go back to clients card to see info)
Other btns in PamatsF is more for aftermath and overall view whats have happened about vaccinations, medicine and so and so..
About Komb_id (eng would be Combo_ID and KombiT (eng would be - ComboT)
Idea, was and is, to create combo box in Vaccination table (Vakcinacija_tab), where i can select different vaccination type where these types, after all, can count with what kind of ilnesses and how much animals i have done. that is why there is little bit circus in my opinion but i couldnt think other idea how to get what i needed.
and it is what is is, because some vaccinations have that ilness covered in and some dont, so if you look in KombiT you will see simple table with true or false statemant fields. where it mark it for every new vaccination type so that databse in end can tell how much that ilness i have covered!
About enforcing referential integrity.
its little bit on purpose. there cannot be any deletions at all. only some data change is there if something incorrect with client data. but if mistake was made and deleted client, i will still see some data with used medications but there will be #deleted shown and i will know. ( in forms there are no options to delete client or records. ) and still, if this client is taken out (IDK WHY) but medications was used and they have to stay for aftermath.
i hope i have explained about basics
if there is any questions, i'm happy to answer and i will be glad for any advice on this thing!