Linking 2 Dimensional Arrays/Table

[Ian Wright]

Hi All,

This is the first post of a frustrated Basic Programmer trying to unlock the power of Access with two guide books

I am trying to program a 'simple' game in which two fields in the character table are co-ordinates X and Y

I have a map table which has fields linked to X and Y

Example : Character moves in direction X, update Character Co-ordinates and update Map field showing how many people are at location.

I created a query with all the fields and then a form from that. On the form I tried to do a simple calc that would update fields in both tables but I am told that it is not updatable

I would be most obligued for any assistance,

Many Thanks,

Ian

 

[The_Doc_Man]

If the query contains a formula that is an aggregate e.g. SUM() then it is not updateable. That's a first-blush response.

If the query doesn't specify the key field, that's another "gotcha" to block updates. If the key is a compound key, extend this to "query doesn't specify all key fields."

If neither of the above is helpful, post a summary of the table structure. I.e. Identify the PK for the tables, summarize other contents. Also post the text (SQL) of the query that won't update.

 

[Ian Wright]

Many thanks for your kind reply Doc Man

I will do as you suggest after an urgent drinking appointment connected to the Rugby World Cup Final. Just in case you don't know, rugby is something like Amercian Football but without the padding.

Best regards,

Ian

 

[The_Doc_Man]

I've seen Rugby matches on TV. Based on the way those guys run into each other, I know exactly what they are like because I see it every weekday. It's like New Orleans car drivers without the cars, approaching an intersection without traffic lights or stop signs, and it's rush-hour traffic on the way home. Except you have some silliness having to do with a ball. But really I think it is just an excuse to bash into each other. Male bonding sort of thing. Right?

 

[Ian Wright]

I would more like to think of Rugby as a rich sub-culture that displays all that is finest in the English .... such as drinking and the liberal use of meassured violence Your summary however is not too far from the reality of it though

As it was, we came second but are mature enough not to let a game ruin a good party, I do however feel a trifle jaded today, which hasn't stopped me going for a 7 mile country walk though

As to my problem with access :

Character table is indexed on an ID number and has three other fields, all are numeric, for the X and Y co-ordinates and an order direction

There is a separate table, unindexed which has x and Y co-ords and a field to record the number of people in the location in the second table.

"All I want to do" is read the order direction and say :

If Order Direction = 3 then X=X+1, Y=Y-1 and the value of the Number of people field to increase by 1

It can't be that hard .... errr ... can it