Adding New Record

[Steve D]

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

[Steve D]

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