Theres no easy way to say this so ill just say it in the form of a story. Im looking for advice on which loops and where.

Here goes:

• out of 200-odd fields in the database, i need to run the following against each field.
• extract allowed values using extract function
• place allowed values into an array
• loop the array to be inserted into a db table
• first check records dont already exist.
• if they dont exist insert into table.

ive found myself playing with this for the past two days and getting tangled and tangled in loops.

wondering if anybody can guide.