soccer fixture/competition

[qaccess]

I am creating a soccer fixture/competition for our local soccer club. so far it works. This competition is based on one competition with 12 clubs. The competition is based on a table with 22 competition rounds. Every round contains 6 matches. So i have a table containing 132 records.

I want to use this table for other competitions. I create a query that works.
But now my problem: I can't fill in the query with results.

I enclosed a zip file. Please help me out

 

[KenHigg]

In one query you can't change a value because fields have been totaled and concatenated, etc.

In the other query, the relationships are preventing the updates.

ken

 

[maxmangion]

In one query you can't change a value because fields have been totaled and concatenated

when you have a total query, Access creates a snapshot of data, therefore you cannot change data.

the same goes with your calculated fields ... they will recalculate themselves automatically, therefore you can't change those neither!

 

[qaccess]

Thanxs for the reply

Do i have to create for every team a new table for results. My club has more than 35 teams and they all use the same table tbl_programma for the competition.

 

[KenHigg]

Is this a disposable db (will you ever use it again after this competition)?

ken

 

[qaccess]

history database

Yes, i like to make a history database. Every new season i like to use the table_programma. With the table tbl_elftallen i can change the column schemaID. But the problem is that schemaID should be unique according to the table tbl_programma column club_thuis and club_uit..

Sorry for the dutch words in my database...