# Material sample table in Specify 7 **URL:** \ **Category:** Get Help\ **Created:** [November 30, 2023, 9:48am UTC](https://speciforum.org/t/material-sample-table-in-specify-7/1454 "2023-11-30T09:48:35Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![sorosoro](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sorosoro](https://speciforum.org/u/sorosoro)\ **Post date:** [November 30, 2023, 9:48am UTC](https://speciforum.org/t/material-sample-table-in-specify-7/1454/1 "2023-11-30T09:48:35Z")
I have the MaterialSample table as a subview in the DNASequence table. In Specify 6 it works well, in the image below the “+” button under the SRA heading (my caption for the material sample subview) is green, I can add new entries. But in Specify 7 the “+” button is grayed out. Do I have to do something in Specify 7 to make it work? ![Capture2](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/3/324639083bfc5933e677f3312bcc22966f049cb8.jpeg) ![Capture1](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/a/a66ff1616323bf1a244d3967331fcf22796e6e4d.jpeg) ---
**Author:** ![bronwyn](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/bronwyn/32/5742_2.png) [@bronwyn](https://speciforum.org/u/bronwyn)\ **Post date:** [December 1, 2023, 7:12pm UTC](https://speciforum.org/t/material-sample-table-in-specify-7/1454/2 "2023-12-01T19:12:04Z")
Hi @sorosoro, I have been unable to display MaterialSample as a functioning subview on the DNASequence form while testing this out in Specify 6. Could you share a copy of the XML view def file that you’re using? It would be helpful to see how these table views are defined on your end. Thank you! ---
**Author:** ![AndyBentley](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/andybentley/32/534_2.png) [@AndyBentley](https://speciforum.org/u/AndyBentley)\ **Post date:** [December 1, 2023, 7:32pm UTC](https://speciforum.org/t/material-sample-table-in-specify-7/1454/3 "2023-12-01T19:32:39Z")
According to this ([Specify Database Schema Update for Tissues, DNA Extracts, Sequence Data, DNASequence Runs, Primers, and NGS data](https://speciforum.org/t/specify-database-schema-update-for-tissues-dna-extracts-sequence-data-dnasequence-runs-primers-and-ngs-data/1061)) the relationship does not work that way. The material sample table is a subview of the preparation table and the DNA sequence table is a subview of the material sample table. Something must be off here. Are you sure your SRA table is the Material Sample table? ---
**Author:** ![sorosoro](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sorosoro](https://speciforum.org/u/sorosoro)\ **Post date:** [December 3, 2023, 2:30pm UTC](https://speciforum.org/t/material-sample-table-in-specify-7/1454/4 "2023-12-03T14:30:15Z")
Hi @bronwyn, thanks for looking into this. Here is my fish.views file (it’s a bit messy, work in progress). After reading Andy’s reply, it is strange that the way I used these views works in Specify 6! I hope there’s nothing weird in my Specify installation. [fish.views.xml](https://speciforum.org/uploads/short-url/8cSYwMIsRvdi27mlnWBSXHrYC64.xml) (128.3 KB) ---
**Author:** ![sorosoro](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sorosoro](https://speciforum.org/u/sorosoro)\ **Post date:** [December 3, 2023, 3:07pm UTC](https://speciforum.org/t/material-sample-table-in-specify-7/1454/5 "2023-12-03T15:07:22Z")
Yes, my SRA table is the MaterialSample table but as you explained I used it wrong in relation to the DNASequences table. Thanks for pointing out the update to the database schema. So that explains why my MaterialSample table does not work in Specify 7 but now the strange thing is that it did work in Specify 6! I wonder whether the direct relationship between DNASequences and CollectionObject is going to be maintained in future Schema updates. ---
**Author:** ![bronwyn](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/bronwyn/32/5742_2.png) [@bronwyn](https://speciforum.org/u/bronwyn)\ **Post date:** [December 6, 2023, 7:42pm UTC](https://speciforum.org/t/material-sample-table-in-specify-7/1454/6 "2023-12-06T19:42:06Z")
Hi @sorosoro, Thanks so much for sending that!! As Andy relayed, MaterialSample as a subview of DNASequence is no longer supported in 7. After some more testing in 6, we were able to get MaterialSample under DNASequence like you said! ![image](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/4/43c5f4e3f49313de856d600c9eb4c48712eb6bce.png) As for the direct relationship between DNASequences and CollectionObject, we are confident this will remain in the future to maintain compatibility. Thank you! ---
**Author:** ![sorosoro](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sorosoro](https://speciforum.org/u/sorosoro)\ **Post date:** [December 6, 2023, 8:02pm UTC](https://speciforum.org/t/material-sample-table-in-specify-7/1454/7 "2023-12-06T20:02:42Z")
Thanks @bronwyn. I guess that means there is something weird with 6. > [@bronwyn](#): > > As for the direct relationship between DNASequences and CollectionObject, we are confident this will remain in the future to maintain compatibility. Good to know!