Home : Products : Aspen : Adding user defined fields to Samples at Login
Q10207 - HOWTO: Adding user defined fields to Samples at Login

I Added fields to Samples at Login and I want them to get replicated.

 

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

You will need to modify the following queries.  Add your new fields from the SAMPLES, SUBMITTERS, MANUFACTURERS, TESTS or TESTGROUPS Tables to the query grid. 

 

To replicate Sample information:

Add your new fields to the samptemp table and the following queries:

  • makesamptable
  • Rep To Samples
  • Rep To Samples - No Tests

 To replicate Submitter information:

Add your new fields to the subtemp table and the following queries:

  • makesubmittertable
  • Rep To Submitters

To replicate Manufacturer information:

Add your new fields to the mantemp table and the following queries:

  • makemanufacturertable
  • Rep To Manufacturers

To replicate TestGroupo information:

Add your new fields to the testgrouptemp table and the following queries:

  • testgrouptemp append
  • Rep To TestGroups
  • Rep To TestGroups2

To replicate Test information:

Add your new fields to the testtemp table and the following queries:

  • testtemp append
  • Rep To Tests
  • 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 2:00 PM.
Last Modified on 1/31/2008 10:32 AM.
Last Modified by No Author Name Available!.
Skill Level: Novice.
Article has been viewed 3714 times.
Rated 5 out of 10 based on 2 votes.
Print Article
Email Article