Jump to content

Problems with going to related record


merkaba22
 Share

This topic is 5655 days old. Please don't post here. Open a new topic instead.

Recommended Posts

In table one there is a "full_name" calc field that combines the first and last name.

In table two there is an "extras" field that has a value list to choose from the "full_name"s of table one -- once chosen sucessfully triggers several lookups in table two, as it should.

There is "relationship1" set up in table one to table two, full_name::extras.

In setting up the script step "go to related record" in table one, the "relationship1" is seen, the option for using the external table is seleced and the layout for table two, form, is selected as well.

When trying to execute the script, there is a message that the operstion could not be completed because the target is not a part of a related table.

What am I missing?

Link to comment
Share on other sites

I don't mean a recommendation on recognizing abreviations, very funny,ha ha ...:P

What I don't understand is why FM will allow you to complete the script step, GGRR, where it inherently sees the relationship and then when you attemp to use it, says its unrelated?:

Link to comment
Share on other sites

Exactly as Comment says it, but you were used to a script per file under fm6 ...but if had paid more attention to page 57 in the whitepaper would have stumbled over this:

In previous versions of FileMaker Pro, the focus or context of a given operation was implicit in the design, since FileMaker Pro has supported only one table per fi le and only one window per fi le. These facts, coupled with the FileMaker Pro single-threaded architecture, ensured that the developer was always aware of the precise context of where a script was functioning. A script would only operate on one window of a given fi le because that was the only window that could exist.

--sd

Link to comment
Share on other sites

This topic is 5655 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.