code:

---

New Record Request

Set Field ["Begin Week", "Week Start Day"]

Set Field ["First Name",""John""]

Set Field ["Last Name",""Doe""]

New Record Request

Set Field ["Begin Week", "Week Start Day"]

Set Field ["First Name",""Jane""]

Set Field ["Last Name",""Doe""]

New Record Request

Set Field ["Begin Week", "Week Start Day"]

Set Field ["First Name",""George""]

Set Field ["Last Name",""Smith""]

---

is there anyway to do this in a loop instead of the way i have it and then connect it somehow to my employee database that has a record for each employee.. and create a new record for each employee so i don't have to write those four lines of code for each of the employees... that could get really tedious.

-------

worked on it a little.. this is what i have so far, but i'm not sure how to stop the loop, and i'm also not sure how to make it go to the next record in the relationship.. so right now it just continually creates a record that has the name of the first record in the userlogin database.. but it is pulling the name from the userlogin database so atleast my relationship is set up right.

code:

---

Loop

New Record/Request

Set Field ["Begin Week", "Week Start Day"]

Set Field ["First Name", "userlogin::FirstName"]

Set Field ["Last Name", "userlogin::LastName"]

End Loop

---

[This message has been edited by bman (edited February 01, 2001).]

ok i got it.. just not sure exactly what to put into the Exit Loop If [] part

well i figured it out

you seem to talk to yourself alot. I've always heard its okay to talk to yourself as long as you don't answer back. OH BOY, your in trouble.

jeremy