Creating Tables from Records (1 Viewer)

Jonny

Registered User.
Local time
Today, 21:12
Joined
Aug 12, 2005
Messages
144
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, 19:12
Joined
Jul 9, 2003
Messages
16,244
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, 15:12
Joined
May 21, 2018
Messages
8,463
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, 15:12
Joined
Feb 19, 2002
Messages
42,972
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.
 

Gichukipaul13

New member
Local time
Today, 22:12
Joined
Aug 15, 2020
Messages
7
Hello. I want It to be in Microsoft access. As a database. Here is an example
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 15:12
Joined
Feb 19, 2002
Messages
42,972
Please try to reformulate your original question.
 

Users who are viewing this thread

Top Bottom