Justinidea
Board Regular
- Joined
- Apr 7, 2010
- Messages
- 57
Hi Y'all
I have a table with multiple rows for specific groups, something like this:
<colgroup><col style="width: 48pt;" span="4" width="64">
<tbody>
</tbody>
I want to update the User field for all the "blue" records by entering "me" in a form only once.
like this
<colgroup><col style="width: 48pt;" span="2" width="64">
<tbody>
</tbody>
Obviously there are more fields in the table. Also I cannot build a relational table of group and subgroup because my data is not constant. Sometimes "blue" might have three subgroups, sometimes it might have 20 subgroups.
Any suggestions will be greatly appreciated.
I have a vague idea that I might have to use the form to create a new table then run an update query, but I'm thinking there might be a more direct and "elegant" way to accomplish this.
Thanks!
I have a table with multiple rows for specific groups, something like this:
ID | Group | Subgroup | User |
2 | blue | A123 | Me |
3 | blue | A234 | Me |
4 | blue | A345 | Me |
5 | blue | A456 | Me |
6 | green | B567 | |
7 | green | B687 | |
8 | green | B891 | |
9 | green | B912 | |
10 | green | B124 |
<colgroup><col style="width: 48pt;" span="4" width="64">
<tbody>
</tbody>
I want to update the User field for all the "blue" records by entering "me" in a form only once.
like this
Group | blue |
User | Me |
<colgroup><col style="width: 48pt;" span="2" width="64">
<tbody>
</tbody>
Obviously there are more fields in the table. Also I cannot build a relational table of group and subgroup because my data is not constant. Sometimes "blue" might have three subgroups, sometimes it might have 20 subgroups.
Any suggestions will be greatly appreciated.
I have a vague idea that I might have to use the form to create a new table then run an update query, but I'm thinking there might be a more direct and "elegant" way to accomplish this.
Thanks!