KEA Scott

We have several databases that are all interconnected. On them it seems that if we get to many layouts we have a problem where we can not manualy move to the layout using the drop down on the left side of the screen. On a couple we have over 200 layouts 1 has over 350! If I have to get to layout 100 I have to type the number in while in layout mode. I can often get to the first 50 or so layouts without any problem. It seems to be after 75 or so that when I select the layout I get sent to the last layout. Anyone have any idea if this is a bug or what. I can provide any info needed.

Okay I am sorry I was tired and not looking at the matching fields. I guess that is what I get for being tired. Thanks for your help

I am not trying to over write fields all data except for the first 2 in each file go into their own fields. We download files for our orders and the system that we use (yahoo stores) breaks out all the information into different files (I have never had a company do this before.

I am trying to import 2 files into the same table. The first file is a list of line items that are distinguished by an order number field then a line item field. Here is what the file looks like. 9000,1,"Belt","Belt",1,$3.95 9000,2,"Tax","Tax",1,$0.00 9000,3,"Shipping","Shipping",1,$7.60 9001,1,"Shoe","Shoe",1,$16.00 9001,2,"Tax","Tax",1,$0.00 9001,3,"Shipping","Shipping",1,$13.75 9002,1,"trgofoalta","DP-TAB-GODDESS",1,$34.95 9002,2,"ls-minispsin","LS-MINISPSIN",1,$0.90 9002,3,"ls-minispsin","LS-MINISPSIN",1,$0.30 9002,4,"hmugc","HMUGC",1,$3.95 9002,5,"ic3310","IC3310",1,$3.95 9002,6,"Tax","Tax",1,$0.00 9002,7,"Shipping","Shipping",1,$13.15 The second file has the same order number and line item number fields (but not ever line in the line items will be in the option field). The first import works fine. When I try to import the second file matching both the order number and line number it updates nothing. Anyone have an idea. Here is the second data. 9002,2,"ls-minispsin","LS-MINISPSIN","Colors","Silver (+.60)" 9002,3,"ls-minispsin","LS-MINISPSIN","Colors","Yellow"