Copy and Paste Script

[defectivo]

Hi Everyone,

I have a course wait book database for a high school. In an outside database, I have a list of all courses being offered for that year.

I have it set so that when a user clicks a field, it opens up this database which lists the various courses. I would like for users to be able to click "copy to course request" and for this button to copy the fields course, grade and period into the corresponding fields in my course request database.

Is this possible without a complex portal?

[Breezer]

Try to use the script step "SET FIELD []" instead of copy.

Set Field[ThisTable::CourseName;OtherTable::CourseName]

or better still, have a relationship using a TO that will lookup the field contents for a maching key field.