I have a scenario where I have 2 linked tables, TableA and TableB. They are linked by the ResultID field, and in TableA this is a unique incremental field, and in TableB there could be several records that contain this RecordID. I also have a number field on TableB called Score. Both tables have fields called Home.

My question is I need to increase the value of Score by 3 if Home on TableA has the same value as Home on TableB. From reading up I guess I need a query but am unsure where to start.

Thanks in advance for any help,
A struggling Lotus Notes developer!!!

Please don't post your question in more than one Forum. If you can't decide where it goes, General is always a safe bet. Your identical post in the Tables Forum has already been addressed. Check there, and followup if you have further questions.