Really need some Numbers 09 Applescript help please.

Hi All,

I am attempting to use Applescript to allow me to collect the values of a pair of columns on one table and store them in an array then to use the values of one of those columns and compare them to the values of a column in another table and populate the coresponding second column of that other table with the second column stored in the array from the first table by comparing their coresponding matching values in the first column.

That was a real mouthful so to de-confuse you here is an example :-)

Table 1:

Name | Age | Skill | Diet

Fred | 35 | Programmer

Jane | 40 | Analyst

Andy | 20 | Slob

Peter | 22 | Gardener

Table 2

Name | Diet

Fred | Vegetarian

Eddy | Meat Eater

Boris | Vegetarian

Peter | Pescetarian

In this case I would need the script to add the Diet column values from table 2 to the Diet column in table 1 when I get a match in the Name columns of both tables (for Fred and Peter in this case) So it's kind of merging data between two tables.

To give you this:

Table 1 (Updated)

Name | Age | Skill | Diet

Fred | 35 | Programmer | Vegetarian

Jane | 40 | Analyst |

Andy | 20 | Slob |

Peter | 22 | Gardener | Pescetarian

I'm very new to Applescript so this is giving me total grief.

Any ideas please anyone as I am at the end of my tether and have wasted hours trying to figure out where to start even:-(

Cheers in advance

Paul :-)