I have 3 tables... size color and style... ex. Size 24 50 Color red yellow green Style fork knife spoon What I need to do is.. have one table that has color style name ex. 50 red knife 50 red spoon 50 red fork 24 red knife 24 red spoon 24 red fork etc... I though it easier to do the three tables and combine somehow.. vs typing out 120 lines.

Yes you can You can use a select statement based on your table structure to output a file, then load that into a new table. The following SQL statement will kick out every possible combination of style, size and colour (use in Query design view) SELECT size_table.size, colour_table.colour, style_table.style FROM size_table, colour_table, style_table This info can then be loaded into access as a new table but remember you'll still need a primary key on this new table.