G
Guest
I need a query to be updateable, but than cannot lookup values for several of
the columns.
The query has a user input race finishes in a column. Automatically I need
the points column to be updated. For each finishing position, there is a set
number of points--how can I look points without a join.
Note that I have multiple tables, and joins, for race data, drive info, race
classes, etc. The query is updateable until I add the points table join.
Suggestions? Shouldn't this work?
the columns.
The query has a user input race finishes in a column. Automatically I need
the points column to be updated. For each finishing position, there is a set
number of points--how can I look points without a join.
Note that I have multiple tables, and joins, for race data, drive info, race
classes, etc. The query is updateable until I add the points table join.
Suggestions? Shouldn't this work?