I have a table (1) which contains a ticket field and other fields. I need to update a field (x) in this table (1) with the values of a field (w) in a second table (2) which contains the same (related) ticket field.
However in table (2) there may be more than one record with the same ticket number with different values in field (w) - in which case I need the field (x) in table (1) to be updated to be a concatenation of all of said records from field (w) in table (2).
I am relatively new to databases but have been using Excel and VB for years. Can I achieve this using a query method alone, if so how would this best be achieved?