Search / Find / then insert problem...

[lonesomejubilee]

I don't know where to put this post, so I thought I'd start in scripting.. so I have two tables, a MAIN and a EMPLOYEE... and basically here's what I want to do...

I want to be able to do a search for a name, which returns all employee info (not a problem).. but then I want to insert info from that record into another table, but I can't get that part to work.

Currently I can get the two things I want to do to work separately.. that is (1) do a search (easy part).. and (2) separately I can get a record info to insert into a notes field based on criteria.

Why after I find the record I want, can't I get the SetField calc to work? The fields are related, so shouldn't it just insert the info?

V

[mr_vodka]

Post the relationship structure and the calculated result part of the set field command.