Hi. I've got a database of IP addresses with two tables:

Table 1 - IP_Addr

Table 2 - IP_Usage

Table IP_Addr stores individual (and unique) IP addresses

Table IP_Usage tracks the dates that I've seen this IP address in my email (I get this data from an AppleScript in Entourage)

I want to do the following steps in AS (and combination of FM scripts if needed)

1. take a new unknown IP address from Entourage

2. Test to see if it is already in Table 1

-- If no, then (1) add a new record in Table 1 with the IP address and add a new related record in Table 2 with the date

-- If yes, then add a new related record with the date

I've been struggling, but not getting very far. Any help would be appreciated.

Steve

Forgot to mention that the match (key) field is the IP address.