duplicate lookup values

[andy33]

I am very new to access. I have created a table with fields in which I have put in lookup values. The table was very general and large so I decided to to create another table but I want to use a few of the lookup dropdowns in the new table. Example: my weather field has a dropdown to pick- clear/cloudy/windy/ rain/snow freezing rain. My temperature field has temp ranges from <20 thru >80 by 5degree increments. Those I would like to bring over to my new table instead of re-typing all the info(which i already did) piece by piece. Sorry for the non-tech explaination. I was keeping my logs all on paper when my wife noticed and said why not put it in the computer it would be easier! Thanks Andy

[hertfordkc]

Your description leaves me unsure of what you are trying to do.
Did you decide you didn't like an existing table, so you are creating a new one and wanting to retrieve values from the old table?? Or are you having trouble using lookups (comboboxes??) to insert values into a table. Or ??

[andy33]

Thanks Hert. I created an additional table with less fields than the original and made a new table with those fields from the original table but a few have the same values in the lookup boxes. IOW I have taken a large table and made 2 smaller with 5 of the same fields in each plus several other fields unique to each one. I was able to go to design view and copy and paste the values from the orig table to the new table, but was wondering if there was another way to do it. Thanks ,Andy