Re: Populating a field from account login...

In article <c338r1taqomuhpmtrqqf95oh0jni4s58j1@xxxxxxx>, VoicesInMyHead
<not@xxxxxxxxx> wrote:

> Well... apparently I am still getting the id 10 t error...
>
> Account Field:
> Get(AccountName)
>
> The Account Field is working great - when I login in with each different
> account
> - it changes to the account I am using.
>
> Now, the Lab Field also changes with each account change - however, Lab Field
> now changes on all my records. Neither field is set for global storage.
>
> Lab Field:
> Case (
> account = "lab011" ; "Main Lab";
> account = "labt012" ; "Lab #2";
> account = "lab013" ; "Lab #3";
> "EVALUATE"
> )
>
> On a side note, once I get this working, I need at have each lab only see
> their
> own records. Each lab has it's own login (obviously), and I created a custom
> privilege set for each. But what kind of script am I looking at making so
> they
> only see their own entries? Find or Omit or a combo of both?

If "Lab Field" is a Calculation field, then it WILL change whenever any
data it's based on changes (ie. when "Account" is changes) - that's
what Calculation fields are meant to do.

If you want "Lab Field" to stay static once it has data, then it should
be a normal Text field using an Auto-enter calculation (using the same
actual Case function) - that way the "Lab Field" data will only be
calculated once, when the record is first created.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
.

Relevant Pages

  • Re: Populating a field from account login...
    ... The Lab field did not need the database:: in front of it... ... >I am trying to populate a field with text, depending on what account logs into ... >Works Fine on the layout and as a background field. ...
    (comp.databases.filemaker)
  • Re: Populating a field from account login...
    ... The Account Field is working great - when I login in with each different account ... Now, the Lab Field also changes with each account change - however, Lab Field ... VoicesInMyHead ...
    (comp.databases.filemaker)
  • Populating a field from account login...
    ... I am trying to populate a field with text, depending on what account logs into ... The Account field I have set up as a Calculation: ... Works Fine on the layout and as a background field. ... The Lab field I have also set as a Calculation: ...
    (comp.databases.filemaker)
  • Total a caluclation field.
    ... calculation field. ... I need to summarize the group totals based on which account ... I need the Sum of TotalPrevDecAmt. ... Steve ...
    (microsoft.public.vb.crystal)