hi!

i got a table containing info of 2 different products. and now i would like to split it so that each table only for 1 product.

but there is query based on the original table, the question is after splitting, and updating the query, the form doesn't work properly any longer...

a bigger problem is the form created based on that query has loads of vb code doing quotation, so it is costly to remake it...

thanks in advance

I think you need to rethink what you are doing. You should have a products table, but not a separate table for each (doing so can only cause you heartache and grief further down the road). Do a search on the forums here for normalization and, if you put in Pat Hartman in as the poster in the advanced search, you can get some really good info.