(Apologies in advance if this is a dumb post, I'm a totally new VFP programmer struggling to find resources for beginners!)

Is there a way to dynamically assign names to tables at runtime? I want to do something like:

SELECT someValue FROM someTable TO someVariable
CREATE TABLE someVariable (fields go here etc)

without ending up with a table called 'someVariable', so e.g. if the value of someVariable is 351145 the table is called '351145'. So far I just end up with a table called 'someVariable'.



I'd appreciate any advice, thanks in advance,

Paul