Sql

I keep getting action failed everytime I try doing this:

UPDATE soft_lic
SET [soft_lic].[used_lic] = [soft_lic].[used_lic]+1
WHERE (
SELECT [soft_lic].[recordnum]
FROM soft_lic
WHERE (
SELECT [PC_Soft].[recordnum]
FROM PC_Soft
WHERE(
SELECT MAX(ID)
FROM PC_Soft)));

If someone could help me it would be greatly appreciated.

Mike

What database system? What is the error message?

I'm using M.S. access 2000 unfortuntely; and this is the "view SQL part of the design query.

I have gotten other joins to work but not an update.

Error:
Action failed

Macro name: add_lic_relationship
Condition: true
action name: open query
arguments: upkeep_lic, datasheet, edit

Does Anybody Have a Clue What is Possibly Wrong, so you can Steer me in the right direction????

That sql looks wrong to me, I have never seen the syntax where= (<subquery>) it is usually where table.column = (<subquery>)... what is it comparing is it just the existance of a row?

Here's how I would expect it to look:


Which simplified I believe is the same as:

Thank you