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.
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:-
Excel Sheets From Access Table OP "avalve" asked this question on Access World Forums:- "Howdy! Let me make a small scenario. Let's say I have a table with fields CarMake/CarModel/Year/Color. What I am trying to do is to export the table to a single Excel Workbook with each CarMake having their...
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?
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.