Showing results for 
Search instead for 
Did you mean: 
Scott_J Frequent Visitor
Frequent Visitor

More than one table needed for drilling?

Hi, New here so bare with me.  I have one table.  One field in the record is furniture type.  Another field is manufacturer.  So lets say there are ten records that have the value "Sofa" listed in each record under the furniture type column.  Now the manufacturer field for "Sofa" has 10 different manufacturers, each manufacturer is listed in it's own record with Sofa.  The table has more records, the same logic applies for Bed, End Tables, etc.  I want to be able to click on a visual that says "Sofa" for arguments sake and have that drill into the manufacturers.   Do I need to break up the table into two where there is a manufactures table and the furniture table?  Can I do it from the one table?