Can we create a new table which would import the same structure as the previous table? RRS feed

  • Question

  • Hello everyone,

    I want to create a new table that would use the same structure as the other table I have created. Is their any SQL query that we could use to import the structure or a template that would help me create one.

    I am aware of the process of using "copy - paste" method, but I would like to execute the same functionality using a button in my Form.

    Example: I have a main Form called "M" and a customer table called "C", i would name this customer table for a company say "xyz". I would like to create another table called "C", for a different company (using same structure of "C"). I want to use this creation as a button called "new" in my main form "M".

    Please share your expertise, so that it would help me in my project. 

    Thank you,

    Wednesday, July 12, 2017 12:57 AM