March 22, 200718 yr 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
March 22, 200718 yr Post the relationship structure and the calculated result part of the set field command.
Create an account or sign in to comment