Creating a new Main Table

[Waldin]

Good Day

My Main Table in my Database is "Quotation", what do i need to do in order to create a new Main Table called "Quotation Tracker" and "Quotation" would now be under "Quotation Tracker"

 

[MarkK]

Is it a new table or are you just renaming it?
In respect to naming a table, there is no need for terms like 'tracker', or 'info', or 'data', or 'records', and so on. A table is filled with 'info', and it 'tracks' 'data' using 'records', so to it an unnecessary redundancy (which is itself redundant) to use such terms in a table name.
An efficient table keeps track of ALL instances of a particular type of thing in respect to your database system. Whether a thing is 'active', 'in progress', 'out of date', 'green', '12inches', or whatever, all of these are dimensions of your type, and would be represented by fields.
My 2c...

 

[GaryPanic]

give it a different name such as quotatiom tracker as the filing is alphabetical or rename the quotation tbl to quotationtbl this would make quotation {space} tracker appear above it

G

 

[KenHigg]

I think this begs the question what do you mean by having one table 'under' another?

 

[Waldin]

thanks guys, Quotation cannot be my main table anymore due to certain functions i need my system to perform, so i want to create a new table which will be my main table in other words "Quotation will answer to the new table" do i create this table like i would create an ordinary table or is the process different?

Regarding the name of the table, my system is called "Track" and its a quoting system so the next best thing after "Quotation" is "Quotation tracker".

but i could rename it if its really necessary.

 

[MarkK]

In respect to how a database works there is no concept of a 'main table.' The distinction 'main table' is subjective and can have no specific impact on how anything functions.

I don't understand what you mean that a table "will answer to" another table.

There is one process for creating tables.

Track is that thing you can do for CDs, Invoices, DogSpecies, BuildingMaterials, anything. Obviously you are free to name anything in any way you see fit, but I strongly recommend you not use any spaces in anything you name in a database.

Hope this helps,

 

[Pat Hartman]

A more common distinction is made between "master" tables and "transaction" tables. Master tables define entities such as Customers, Products, Students, Pets and manage data that is relatively static. Transaction tables record actions such as Orders, ClassAttendence, DoctorVisits, Deposits, Checks and each row represents some action that happens to or between entities.

 

[jdraw]

I recommend you read this article on Relational Design
http://forums.aspfree.com/attachment.php?attachmentid=4712&d=1201055452
and review your current approach.
Good luck with your project.

 

[Waldin]

Thanks Man, il look into it.