AnsweredAssumed Answered

Value List

Question asked by JimZ on Jul 1, 2016
Latest reply on Jul 2, 2016 by bigtom

Hello and thank you for your time,

 

I am trying to minimize the number of tables I use for a solution I am making. I used to have a table for every type of item that could be ordered on a build order database (about 10 tables not too many but kind of a pain to script). What I am now trying to do is instead make one table with a category field that will denote each type of item. However I want to then put these values into a value list depending on what category they are assigned. For example in one field (lets call it dingy) on the build order only information in the same record as category B can be entered. So in the dingy field only values from lets call it the Sail Field that are in the same records as the B values in the category field. I hope this isn't to confusing and again I thank you for your time ad help!

 

Category (Field Name)

(entries in Category over multiple records)

A

A

B

C

A

B

B

C

 

Thanks,

JimZ

Outcomes