Home : Adding user defined fields to the Sample Reference Library
Q10206 - HOWTO: Adding user defined fields to the Sample Reference Library

I Added fields to the Sample Reference Library and I want the ability to replicate them and to add them to Samples at Login.

 

Information in this Article applies to:

  • Aspen version 7.x
  • Aspen version 6.x
  • Aspen version 5.x
  • Aspen version 4.x
  • Aspen version 3.5
  • Conifer32 version 4.0

Replicating Sample Reference Library fields:

You will need to modify the following queies.  The first query envolves the fields for the Sample Reference. The second query is for replicating fields you may have added to the Test Groups associated with the Sample Reference.  The third query is for replicating fields you may have added to the Tests associated with the Sample Reference.  Add your new fields from the SampleRefLib table, Sample_Reference_Testgroups table or Sample_Reference_Tests table to the query grid.

  • Replicate SamRef Selection
  • Replicate SamRef TestGroups
  • Replicate SamRef Tests

Getting Sample Reference fields to show up at Login:

You will need to modify the following queries.  Add your new fields from the Sample Reference or Sample Reference TestGroups or Sample Reference Tests Tables to the query grid.  The first two queries are evoked when you click Add button after selecting a SampleReference from the Reference Libray combo box.  The last 6 queries are only evoked when a Reference ID is used at Login.

  • Login Samp Ref Test Groups
  • Login Samp Ref Tests
  • Login SampleRefID
  • Get Sample Ref Groups
  • Auto Login Sample Reference Groups
  • Auto Login Sample Reference Tests
  • rep to testgroups2
  • rep to tests2

 

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 11/17/2005 1:48 PM.
Last Modified on 1/31/2008 10:34 AM.
Last Modified by No Author Name Available!.
Skill Level: Novice.
Article has been viewed 3746 times.
Rated 2 out of 10 based on 1 vote.
Print Article
Email Article