I do hope the last post gave a clearer picture. If someone can just tell me if using a trigger is the best way to handle this situation. ...

Sorry, I guess I did not explain enough to get a clear picture of my intentions. Say the following record gets inserted into Table1:

Table 1

VendorID: V001

Vendor_Category: Max1

Item_Number: IV1001

Vendor_Part_Number:...

This would be triggered by an insert into Table1. Then lookup the list to then insert multiple records back into Table1. As I am typing this I realize...