Hi Guys,
i have relationships like (not look at model data, this is only sample, you can propose your data for it like tblCats or something different) in attached picture.
and i am getting all data for tblDescription from Excel. I have the same field names there plus People. I have not only DescriptionID in ExcelTempTable so only way to check if some new descriptions was added is to create inner join between ExcelTempTable and tblDescription.
I am wondering it is good what i am thinking.
Fields data in tblDescription can be changed so i have to run update query and if there is not such description, add description to tblDescription and furthermore add this new descriptionID for spefic PeopleID in tblDescriptionPeople.
What i want to do is:
1. Import excel table
2. Join all fields via inner join in tblDescription and tblExcelTemp to be sure what we want to update
3. For example i will have only one field data different, eye color will change from blue to black for Man "Paul". How to check this only one? How to do proper query?
4. To check if specific DescriptionID exists, i have to join tblExcelTemp with tblDescription and what is not in tblDescription - append, correct?
5. After that i have to check if spefic DescriptionID for specific Man from tblPeople exists, if not add it to tblDescriptionPeople, correct?
So the last 3 points are very important and i need to help with them.
Please help,
Best,
Jacek
i have relationships like (not look at model data, this is only sample, you can propose your data for it like tblCats or something different) in attached picture.
and i am getting all data for tblDescription from Excel. I have the same field names there plus People. I have not only DescriptionID in ExcelTempTable so only way to check if some new descriptions was added is to create inner join between ExcelTempTable and tblDescription.
I am wondering it is good what i am thinking.
Fields data in tblDescription can be changed so i have to run update query and if there is not such description, add description to tblDescription and furthermore add this new descriptionID for spefic PeopleID in tblDescriptionPeople.
What i want to do is:
1. Import excel table
2. Join all fields via inner join in tblDescription and tblExcelTemp to be sure what we want to update
3. For example i will have only one field data different, eye color will change from blue to black for Man "Paul". How to check this only one? How to do proper query?
4. To check if specific DescriptionID exists, i have to join tblExcelTemp with tblDescription and what is not in tblDescription - append, correct?
5. After that i have to check if spefic DescriptionID for specific Man from tblPeople exists, if not add it to tblDescriptionPeople, correct?
So the last 3 points are very important and i need to help with them.
Please help,
Best,
Jacek