Storing the company address

[andy_25]

I have a database and recently the company have changed their telephone number.

The address on all the printed reports was manually entered into a label.

I am undertaking the task of changing this so that the address can be edited without me.

Should I store this address information in a variable or use a table? Any thoughts?

 

[gemma-the-husky]

table - then its modfiiable without any more programming

 

[Lightwave]

Concur with dave

I presume you are aware that if you store the company address with primary keys and if the label address is linked to this primary key then if you change any of the details within the linked address record all labels will automatically be updated. In this way you can create a form which shows this record that can be edited as and when you see fit. Probably by anyone

 

[Simon_MT]

Whilst you may not need this and its a bit of an overkill, I have Company in all my records. There is a query CompaniesCurrent and this can be used on the main Menu. So whenever Co is used the Default value can be handled:

1) =DLookUp("[Company]","[CompaniesCurrent]")
2) =[Forms]![Menu]![Company]

Simon

 

[andy_25]

Cheers for the input guys. That is exactly what I was thinking, I was just checking that no one would argue that it is a wasted table.