Creating Tables from Records (1 Viewer)

Jonny

Registered User.
Local time
Today, 20:13
Joined
Aug 12, 2005
Messages
141
Having a table with tens of records: Honda, Toyota, Lexus, e.t.c
Required to create a table for each record and to link ID of each table to that record.

Could this be done in a code?
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 18:13
Joined
Jul 9, 2003
Messages
11,784
It depends a lot on what your current table structure is like. You need to provide a lot more information. As an aside I thought you might like to have a look at at something I created recently which shifts car makes from a table into lots of different Excel spreadsheets, a little bit like the problem you describe, but doing it in Excel:-

 

MajP

You've got your good things, and you've got mine.
Local time
Today, 13:13
Joined
May 21, 2018
Messages
3,247
Sure it can be done. You can create tables in Access via code and dynamically add fields. So you can read your current table and break that into multiple tables. Can you explain the purpose?
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 13:13
Joined
Feb 19, 2002
Messages
29,167
Why in the world would you want to create a table for each brand? This is spreadsheet thinking. Please tell us what you are trying to do and we'll help you accomplish it without resorting to turning your database into an unmanageable spreadsheet.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom