Hi,
Sorry for the title - Not really sure of the name of the issue we're having :banghead:.
I have two forms made up from tables from the server 1) Market Categories, 2) Market Countries.
The object of the database is to categorise products from another table (Stock) based on tick boxes, which is obviously simple enough. What the second table is made up of is more tick boxes split into three sections - UK & Channel Isles., EU & ROW. What I need to do from my categories table is when the user ticks the boxes they are then able to push a button on the form to update the countries table in bulk (It is not always possible to sell all products to all countries etc.) so it is quicker to untick the ones not sold to!
I had a idea of building an update query that set all records to one, but this offers to update 3,000 + stock records even though I have defined the relationship being two matching fields on the two tables.
Any thoughts on this?
David
Sorry for the title - Not really sure of the name of the issue we're having :banghead:.
I have two forms made up from tables from the server 1) Market Categories, 2) Market Countries.
The object of the database is to categorise products from another table (Stock) based on tick boxes, which is obviously simple enough. What the second table is made up of is more tick boxes split into three sections - UK & Channel Isles., EU & ROW. What I need to do from my categories table is when the user ticks the boxes they are then able to push a button on the form to update the countries table in bulk (It is not always possible to sell all products to all countries etc.) so it is quicker to untick the ones not sold to!
I had a idea of building an update query that set all records to one, but this offers to update 3,000 + stock records even though I have defined the relationship being two matching fields on the two tables.
Any thoughts on this?
David
