Might be dead simple but ive struggled with it a while now.

I want a set field by name script to automatically select current table and then a field called "bin"

I cant make Get ( ActiveFieldTableName ) to work, or set variable or any other solution...

The problem is the whole select field value must be within "" and Get ( ActiveFieldTableName ) & "::bin" does not work because of this.

reason?

I have a bin field in most table and I want to be able to use one single script and change the current table row bin field, instead of making one for every table/layout i have.

Many thanks for any tips or help.

Have you tried Quote( Get (ActiveFieldTableName) & "::bin") ?

corrected per subsequent post to insert correct double colon

Jup.

It dosent work. The result of that is only ":bin"

so the table name is not following...

Why would you have a "bin" field in every table, anyway? I question your data model.

hehe. I question it sometimes aswell. Its a test to create a flag for hiding the row. But the current table function would still be nice to have.

if I run Quote( Get (LayoutTableName) & ":bin") I get the correct result, but it still dont wanna change the value... ill keep on trying. Thanks for the help so far.

Is there an "active field"?

The Quote() example should have a double colon, not a single.

Why would you have a "bin" field in every table, anyway? I question your data model.

hehe. I question it sometimes aswell. Its a test to create a flag for hiding the row.

That is worth questioning, IMHO.

Ok. maybe its a bad ide. It is however just en experiment to test the different security settings in fm. Anyway. I think this discussion gave me some new ides to think about.

ps

The Quote( Get (LayoutTableName) & ":bin") gives me the right result but it dont work anyway. And the :: colon just results in a error not finding the field. But im quiting this test and will solve it some other way.

But thanks for all the help anyhow.