Shadowfax Posted August 16, 2005 Posted August 16, 2005 I am constructing a fairly complex database (at least it seems that way to me!), but I have encountered a very simple yet annoying problem along the way. For the purpose of this discussion, I'll only mention the two tables involved in my problem. I have two related files, one is a "Master" file and the other is a "Slave" file. The Master contains a portal that lists all the records in the Slave file. When a field is clicked on the portal, I would like the data from a corresponding Slave field copied into a field on the Master file for searching purposes. Unfortunately, my script only copies the information from the very first record of the Slave file. It seems to completely ignore the portal row's position. Here is my script (you can view the attachment to see the files for yourself): 1. Go to Related Record ["Rel"] 2. Go to Field ["RecipientField"] 3. Set Field ["RecipientField", "GetField("Rel::OtherInfo")"] Any suggestions are welcome. PortalProblem.zip
Søren Dyhr Posted August 16, 2005 Posted August 16, 2005 You make it way too complicated, all it takes is this: Set Field [ RecipientField, Rel::OtherInfo ] --sd
Shadowfax Posted August 17, 2005 Author Posted August 17, 2005 Gosh, those extra steps were unnecessary. You're suggestion works like a charm. Thanks for the help!
Recommended Posts
This topic is 7039 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now