Update multiple yes/no boxes at by only clicking one

[stephvliet]

Hi All

I have several tables with the same Fields, I want to just tick one table and update the other tables that have the matching information as ticked. I hope this makes sense, Is this possible?

Hopefully someone can help this poor girl who has been thrown properly in the deep end but learning to swim.
:banghead:

 

[Uncle Gizmo]

>>>I have several tables with the same Fields<<<

Why?

Put it all in one table, then what you ask for becomes easy....

 

[stephvliet]

Hi Uncle Gizmo

Thank you so much for your help, I have put it all on one table. There are a few duplicate Columns in my records, I want to be able to update the same column of duplicates at once to say Yes. Does that make sense?

 

[Uncle Gizmo]

Ah! Do you need the duplicates?

 

[Uncle Gizmo]

Actually rereading your question you said duplicate columns I assumed you meant duplicate rows. Please explain why you have duplicate columns?

 

[Uncle Gizmo]

BTW ... Keep all your old tables, and make backups of your access file regularly.

 

[stephvliet]

Sorry to be so confusing I am so new to this and haven't quite got the jargon right. I meant duplicate rows. Duplicate values in the columns!

 

[Uncle Gizmo]

Do you need the duplicates?

 

[stephvliet]

Yes I do, or else I could run a duplicate query.

 

[Uncle Gizmo]

So how do you distinguish between the duplicates?

 

[Uncle Gizmo]

You jumped the gun a bit by combining the tables together, (which is a good thing) but there was another step that needed taking before you combine them. Because you have information from separate tables which is the same, then you need to add an identifier when you append the table information together. One way to do this is to add an extra field to the append table which records a number signifying the table the record came from.

 

[stephvliet]

I am probably not making myself very clear, Not all my fields are the same in the record but some of my fields are duplicated, There are no duplicated records.

 

[Uncle Gizmo]

By the way I see you have another thread running with essentially the same question. I would suggest that you delete that thread as it is bad form to make double posts.

Unfortunately it has already received a reply and deleting it could well be seen as a bit rude, so I suggest you have a word with the other poster and let them know what you intend doing before you delete the thread.

If you don't delete it it may well received more replies and then you will be in a very awkward situation.

 

[Uncle Gizmo]

I am probably not making myself very clear, Not all my fields are the same in the record but some of my fields are duplicated, There are no duplicated records.

Well then I think it would be a good time for you to recap what you are saying because I am also losing track of what you have said. I don't think it would be sensible for me to try and reiterate your question until you have had a think about it yourself.

 

[stephvliet]

You are quite right, I have worked out what I was trying to do, I wanted to update several fields at once to true with the date. I did this by running a query, Thanks for helping me and teaching me Forum etiquette!!

 

[gemma-the-husky]

I think the concern was that, in general, each data element in a database should be "stand alone". Changing an individual value of a given field should have no effect on anything else in your database. Therefore if you have a system where a change to a particular item necessitates changing the same value in other tables, (or other records in the same table)- it may be indicative of less than perfect data design. (ie imperfectly normalised)

Whether this is the case depends on the exact situation in your case, which isn't quite clear.

If the data is correctly "normalised" the data, it is much easier to design your processes.