Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic table question. Please help

Status
Not open for further replies.
TheRealDeal

TheRealDeal

Technical User
Nov 16, 2001
187
US
Is it possible from code to create a DYNAMIC table in memory that is not populated from a make-table query? I already have the code written that gathers the data from multiple sources, but the real issue for me comes to light when I want to use the data for a particular instance and then discard it. I know I can use temp tables, but I want to steer clear of that option, only because my files would tend to get large and I don't want to force compacts.
 
Sort by date Sort by votes
Sounds like you should check out using arrays.

< M!ke >
 
Upvote 0 Downvote
OK, I have in the past. How would you best arrange it so that I have a record #(so to say) and then my 12-15 fields to reference?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

raywood1
  • Locked
  • Question
Reducing a Massive Linked Table
Replies
4
Views
488
dhookom
dhookom
03Explorer
  • Locked
  • Question
Refreshing a linked table (housed on MS SQL Server) now breaks
Replies
3
Views
380
dhookom
dhookom
JayRo71
  • Locked
  • Question
Importing only unique records from excel tables 1
Replies
10
Views
572
SkipVought
S
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
441
SkipVought
S
Lidias13
  • Locked
  • Question
Odata contains fields from multiple tables in single table with different field names - for same
Replies
1
Views
349
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top