Hi,
I don’t know how to deal with some data and tables.
I have 2 types of users:
The users for whom I have information in another database and I must retrieve the data.
The users for whom I have no information in the other database and I must enter the data
I thought about this model:
My DB:
Tbl_all_Users (
User_id (PK))
Tbl_Users_not_in_the_other_db(
User_id (FK),
Name,
Adresse)
The Other DB:
Tbl_Users_in_the_other_db(
User_id (PK),
Name,
Adresse)
The relations:
Tbl_all_Users (1)---------------------------------------------------> (0 or 1) Tbl_Users_not_in_the_other_db
And the table Tbl_Users_in_the_other_db is imported from the other db
What do you think about?
Thx.
I don’t know how to deal with some data and tables.
I have 2 types of users:
The users for whom I have information in another database and I must retrieve the data.
The users for whom I have no information in the other database and I must enter the data
I thought about this model:
My DB:
Tbl_all_Users (
User_id (PK))
Tbl_Users_not_in_the_other_db(
User_id (FK),
Name,
Adresse)
The Other DB:
Tbl_Users_in_the_other_db(
User_id (PK),
Name,
Adresse)
The relations:
Tbl_all_Users (1)---------------------------------------------------> (0 or 1) Tbl_Users_not_in_the_other_db
And the table Tbl_Users_in_the_other_db is imported from the other db
What do you think about?
Thx.