Create a table for companyself ??

[luanhoxung]

Hi, folks !
I need a though for my creation a table.
I nearly completed all the work for using a database.
But I stucked when create our company informations.
For example: My company can change the location(Address) or get a new
permission for sell to a new market.ect.
I mean my company profile can update or can get a extra information.
I used a label for all our document report. But I think when my
company information change I cannot open all those report to amend --

Not convenience !!

How can I create this table ??
Any help will be appreciated
Thanks .
Luan from VietNam

 

[Wayne-I-M]

Hi Laun

You could create a new table to hold the company information that "will"
change. Something will not change so this should be an table. Something
like this

Table1 (for things that will never change)
CompanyName (primary field)
Name of directors
Postal address (if you have one that will not change)
Telephone number
Tax number
etc
etc
etc

Table 2 (for things that "will" change)
AddressID (autonumber)
CompanyName (same as in table 1 - this is the linking field)
Address
Other telephone number (in case you have a different one at each location)
Market name
etc
etc

Use the relationship window to create a relationship between the 2 tables
(use the company name). This way you could have a main form with the company
details with a sub form showing each location the company operates in. This
is use full as you could produce reports and charts to show which ,ocation is
best for the company and many other details.

Also by using the company name in table 1 you could also have different
companies doing bussiness in different locations at the same time and still
be able to record all the details.

Hope this helps

 

[luanhoxung]

Hi Laun

You could create a new table to hold the company information that "will"
change. Something will not change so this should be an table. Something
like this

Table1 (for things that will never change)
CompanyName (primary field)
Name of directors
Postal address (if you have one that will not change)
Telephone number
Tax number
etc
etc
etc

Table 2 (for things that "will" change)
AddressID (autonumber)
CompanyName (same as in table 1 - this is the linking field)
Address
Other telephone number (in case you have a different one at each location)
Market name
etc
etc

Use the relationship window to create a relationship between the 2 tables
(use the company name). This way you could have a main form with the company
details with a sub form showing each location the company operates in. This
is use full as you could produce reports and charts to show which ,ocation is
best for the company and many other details.

Also by using the company name in table 1 you could also have different
companies doing bussiness in different locations at the same time and still
be able to record all the details.

Hope this helps

--
Wayne
Manchester, England.





- Show quoted text -

Thanks, Wayne !
What a deep though !
Thanks a lot
Luan
Viet Nam