AnsweredAssumed Answered

Sometimes a value, sometimes a range

Question asked by swetzel on Apr 18, 2018
Latest reply on Apr 19, 2018 by philmodjunk

I am relatively new to Filemaker and am working on getting some data from some electrical cable standards.  Sometimes the data is based on a specific conductor size (i.e. rows of data based on the AWG size of the wire, like #8, #6, #4, #2, #1, #1/0, #2/0, #3/0. #4/0, 250, 500, ...). Sometimes the data is based on a conductor size range (rows like: #10 - #6; #4 - #1/0; #2/0 - #4/0; 250 - 500).

 

I need to accommodate both kinds of table to look up data from.  Is there a best approach?  Is there a way to relate tables so that you can lookup data that is sometimes a direct match and sometimes in a range of values?

Outcomes