Recent content by SorenIX

Thanks for your answers! One thing though, the client is actualy the tier. So on the table you call events, there's only EventID, Tier, AppID... In my sketch, Table1 is App Table, Table2 is Events Table and Table3 is Tier Table(client at the same time, they're the same thing in this context)

I'm still needing a solution!!! :eek: I was busy with other work but now that's the only thing left... :confused:

This query is not working because it would return a record, while the WHERE clause is only looking for a value to fetch many (possibly) records. Get it?

I thought giving some values would be of better help... Table1 1 | AppA 2 | AppB 3 | AppC Table 2 1 | TierA | AppA 2 | TierB | AppB 3 | TierC | AppC 4 | TierB | AppA 5 | TierC | AppB Table3 1 | Smith | TierA 2 | Bob | TierB 3 | John | TierC So if I run a query that search for...

Hello everyone, I've been looking around to solve my problem. I even went and recovered my old class note about SQL but haven't found anything. And yet I know it's kinda simple... but I just don't remember clearly. In the scheme below, I want to fetch all the info in Table3 for all the Tiers...

Thanks plog, everything seems to be working. Here's the code for the interested ones in the future. Sub Import_Applications() Dim SQL_Update, SQL_LEFTJOIN As String Dim totalApps As Integer SQL_Delete_Rows_From_Tab = "DELETE * FROM Temp_Import_Tab;" DoCmd.SetWarnings...

For that update, I'm having trouble seeing it. I' have to make another temp table with the INNER JOIN results, and then do the UPDATE from this table?

AutoNb is just a way to give the records a number as there could be several rows with the same AppID Impacts_Tab 1 / 10 / AAA 2 / 10 / BBB 3 / 10 / CCC 4 / 15 / AAA 5 / 15 / CCC . . .

App_Tab: AppID (PK) AppName ImpactScore Impacts_Tab: AutoNb (PK) AppID (FK) Impact If I try to delete an ID that is refered in the Impacts_Tab, it asks to remove relations with this record before proceeding.

That's the point, I can't delete records that are in relations with other tables. I'd have to do an UPDATE query?

How would you determine what needs to be updated and how would you update it?

[SOLVED] Database Update With Relations Issue Hello hello! I'm making an Access DB and records are often updated through Excel importations. My problem here is what my code does : Before importing, it deletes every rows in the table. Hence, records with relations won't be deleted. I...

Just refreshing the topic a bit, I still haven't found the solution to the final problem. :banghead: After that it will be all solved! Yay! :D

I've explained it above.

No, it comes from my application not being syncronised with the server database.