M
Martino165
I have created a somewhat complex relational db and would like to
populate the db using EDDs. The EDDs would be the required information
to be uploaded into several tables.
Two questions:
Is an update query the best way to populate those tables using an EDD?
I will probably have no problem if all the fields populated in the EDD
are unique values. I was wandering what should I do if some of the
fields in the specific record are new and some are repeated values
e.g.
table 1contains author and relevant information about author
table 2 contains the publication information
if I uplaod and edd with an author that is not yet entered in the db I
do not foresee having any problems. If i upload an edd that has a
preentered author but a new publication, I would like the publication
to be updated and be assigned to that author, but not for the author to
be added again to that table..
sorry if this is convoluted... any help would be great... thanks
populate the db using EDDs. The EDDs would be the required information
to be uploaded into several tables.
Two questions:
Is an update query the best way to populate those tables using an EDD?
I will probably have no problem if all the fields populated in the EDD
are unique values. I was wandering what should I do if some of the
fields in the specific record are new and some are repeated values
e.g.
table 1contains author and relevant information about author
table 2 contains the publication information
if I uplaod and edd with an author that is not yet entered in the db I
do not foresee having any problems. If i upload an edd that has a
preentered author but a new publication, I would like the publication
to be updated and be assigned to that author, but not for the author to
be added again to that table..
sorry if this is convoluted... any help would be great... thanks