R
R
reboot7772019-06-16 21:21:13
Database design
reboot777, 2019-06-16 21:21:13

Adding a record to a SQL database master table?

I am writing a project using asp.net mvc.
Added database, model. Controllers and views at the same time.
In the health check, there is no option in the view to add multiple records per person.
That is, let's say there are two tables:
1. The main table is (People), where the columns are: full name, date of birth, id_Application.
2. The second table of Cases consists of the following columns: id_of the case, Date of the case, Reason for the case, Mark of completion. It is assumed that there will be many entries, "appeals" per person.
3. Of course connected two tables through an index. (example is conditional)
4. How can I implement the addition of several entries in the table of Appeals per person?
5. Example.
Ivanov...
Date Reason Completion mark
1st record 10.10.10 - reimbursement of expenses 50% compensated
2nd record 10.11.11 certificate certificate issued. Etc.
I don't understand how to implement this. With my mind, I understand that I should somehow encapsulate for one person.
Thanks for the help.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2019-06-16
@reboot777

The second table of Cases consists of the following columns: id_of the case,
Add a columnid_человек
And how then to implement the addition?
On the input form "Contact" ComboBox for selection id_chelovekand input fields for other columns.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question