Probably a simple question. I would like to have a VB written that would create a table with about six fields but two of the fields would be filled out (automatically). It's part of my vendor database, I would like to use all the vendro primary keys to create a new table which would have as many records as there is vendors. The second field I would like to have filled out is the current quarter. There should still be 4 remaining fields (columns) that would enable the user to enter information that would apply to each vendor and current quarter. One thing, if the table has already been created for the current quarter, not a new table should be created but the user should be taken to it... Hope it's not too complex, thank you