>Hi,
>I have two tables, table1 has the following structure
>Table1: dog, howtall, howfast, furtype
>Table2: cats, howtall, hasclaws, food
>
>I have set the relationship between the two, using the field howtall
>
>Now here is my problem, after having set the relationship, I want to copy
>the table to a new table
>
>copy to newtable a->dog, a->howtall, b->cats, b->howtall
>
>But I get an error. How can I copy selected fields from two tables?
>
>Thanks
>Steve
Select a.dog,a.howtall,b.cats from tablea a inner join tableb b on a.howtall=b.howtall into table newtable
Edward Pikman
Independent Consultant