sktmx13
asked on
Add Lookup Column to existing DB on SQL2005
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 :)
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 :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I figured it out but would have appreciated a more in depth approach
ASKER
My Customer Table has 2 columns
ID - AutoNumber
CustomerName - Text 255 Chars (mostly Business Names)
I created a few Customers such as CableVision, Charter, etc... and upsized that table to the existing SQL Database.
tblData has many existing columns but no CustomerName yet.
--------------------------
If we're one the same page - then where do I enter the code you gave me? And how could I add a FK one to many... ?