Add Lookup Column to existing DB on SQL2005
Posted on 2011-03-11
No real question per se. I am just not good at this and do not want to destroy any data.
I created a Column in Access and transfered it to the existing DB via the upload Wizard. (Customers) - I filled a few Dummy Customers in and I can access it through our adp on the new form.
here's where I need the help.
Existing Database (tblDATA) does not have a Customers Column which refers to this now. - I am so not the person to do this but I am stuck with it.
Can anyone guide me step by step on how to create a column in SQL Management Studio and link it with this Customers Table I created?
There are many more linked Tables in there (tblStatus, tblDepartments and they all have an FK, int, not null) description after the name but "alas" I'm too dumb for this :-/
Step by Step solution appreciated - and I promise if it works I'll add a few Boni points :)