Set field has me baffled when it comes to getting information from one file to another. Not a problem between two tables in a single file, but between separate files? Not happening. I've attached a simple db (fmpro12) to show what I mean. I think the problem may be in how the relationships are set up, but i just don't know. I have read a lot in the forum, but most problems are way over my head involving multiple script steps. I want to copy the contents of three fields (two number and one text) from one file to another -- not even necessarily related.
I am on a mac 0s 12.x, lotsa memory, sierra, and am about a quart low on brain fluid at this point. Any help appreciated.
Sorry if the scripts nomenclature is confusing, but they are pretty simple.