Jump to content
Sign in to follow this  

Help with a tally calculation

Recommended Posts

So I'm trying to create a calculation field that will be based on a self relationship. The self relationship is to define all records with the same value in _kf_Cell_Line_ID. The idea is the tally calculation, which I currently call Cell_Line_Rep_Tally, should function in such a fashion in that it will increment by 1 for each new record created that uses the same foreign key _kf_Cell_Line_ID. Obviously it should not change in extant records, only update when the record is newly created.

The notion behind this is simple. In our lab, we may use a particular cell line to produce a certain protein multiple times. We call each growth of a particular cell line a batch. I'm basically trying to create a simple, uniquely identifying 'batch number' for lab techs that would be represented by '(cell line number).(batch number)' where batch number equals the tally of the number of times this particular cell line has been used to grow a batch. i.e. the eleventh batch grown of cell line 4 would be represented as 4.11

I'm hoping this is making some sort of sense. Anyway, I'm not having much luck getting this tally to function properly, as I am quite novice to filemaker, and it's been over 14 years since I used any sort of programming logic :) I was hoping someone might be able to offer me a hint as to how to accomplish this, if my approach with a self relationship and a calculation is even the best way to approach this, etc.


Share this post

Link to post
Share on other sites

thanks, that's certainly the type of functionality I'm looking to create. Much appreciated.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Matt Cudmore 
  • Create New...

Important Information

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