Create new table based on existing table info

  • Thread starter Thread starter Da Viking
  • Start date Start date
D

Da Viking

Hello

Anyone know if this one is possible:
in table1 there are X number of location names based on input from a form,
is there a way to make table2 using the data in table1 as the field names.

Thanks
Hans Soerlie
 
You mean you want field names Boston, Chicago, New York? That would be a
mistake.

Those would be what are referred to as a repeating group, and are to be
avoided. For one thing, you're hiding data in the field name. For another,
it makes querying very difficult.
 
Back
Top