Help on adding fields

[satyen]

Hello,

Hope your all well

Thank you in advance and I would like some help in adding a field in Access 2007. Bearing in mind I am novice to this.

I am adding a exisiting field which is already available on a Global Table and would like to add it on a local table within the same database. Also bearing in mind the db contains main objects - Tables/Queries/Sharepoint lists/forms/reports

Whats the process in doing this? Once added how does the data get populated?

I would appreciate if anyone can help me do this from end to end at the earliest.

I look forward hearing back!

 

[CJ_London]

Is this a one off or something you want to automate?

If a one off, simply go into your table design and add the new field manually, making sure you choose the right datatype.

With regards populating it you need to create an update query which links your existing table to your global table on a unique id.

You have not provided any detail which enables a more detailed answer.

One thing to bear in mind - from what you have described you are duplicating data (in the global table and the local table) which is generally considered bad practice - how would you plan to keep them in sync? Would it not be simpler just to link to the global table and get the data from there when required