L
Lore Leunoeg
Hello
I'm busy with a client application which is working on client-data. Client
data are spread over several 1:n tables in the database. How should I
organize data in the dataset(s) ?
1) Create one dataset for each client with the tables which select only the
data specific to this client.
2) Imitate the table structure and relations of the database, means: one
dataset including one table for all the clients, one table for all the
addresses, one table for all the bankaccounts etc.).
What are the advantages and what are the disadvantages or is there only one
way to do it?
Thank you
Sincerely
Lore
I'm busy with a client application which is working on client-data. Client
data are spread over several 1:n tables in the database. How should I
organize data in the dataset(s) ?
1) Create one dataset for each client with the tables which select only the
data specific to this client.
2) Imitate the table structure and relations of the database, means: one
dataset including one table for all the clients, one table for all the
addresses, one table for all the bankaccounts etc.).
What are the advantages and what are the disadvantages or is there only one
way to do it?
Thank you
Sincerely
Lore