Start Free Trial

asked on

MS SQL Server 2008 Data integrity FK NULL

I'm going to be real lame here and ask an easy question.. I think.. this is to make
up for later when I ask a reeeeaaalllllly hard question and get really fussy. Be warned!

You see I have successfully created a couple of tables. "Table _1 " is now called
"Sales_Rep" as I have saved it thus refreshing the name on the tab. I need
"seller" to be a foreign key referring to the primary key "name" of Sales_Rep but
I think it is okay if it is null? hmm.. yes. I think an unsold Automobile (Table_2) can
be in the database.

Maybe I have to click that relationship jobbie?
seller.jpg

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

I'm in touchy feely Windoze moode. I dont know where to type the SQL right now. Can I right click on something instead?

ASKER

I press buttons dwive me kwayzey
FK-wazyzey.jpg

ASKER

I'm not trying to make this hard. I think we are close this one.

ASKER

That's better. I saved with right names now. Automobile.seller must be Sales_Rep.name. seller FK to
Sales_RepPK.name.
sellerFKname.jpg

ASKER

Now you see Sales_Rep. Sales_Rep (s) he have name(S)
namePK.jpg

ASKER

oh oh., bad danger. soooo many windoze i never asked for
badPKdanger.jpg

ASKER

Okay I done now with kwayzey nonsense? i have no idea.
PKFKdone.jpg

ASKER

Can you read that? It is Foreign Key Relationships Diagalog woohaw.

-Tables and Columns Specifica
Foreign Key Base Table Automobile
Foreign Key Columns seller
Primary/Unique Key Base Ta Sales_Rep
Primary/Unique Key Column name
-Identity
(Name) FK_Automobile_Sales_Rep

ASKER

this is kwayzey awful slow

ASKER

I mean my stooopid awful old puter running Vista.. I save I save It confused.

ASKER

Tables and Columns make me mad. Can't change Forieng key table.

oopsie! got it backards?
ornery.jpg
combobulate.jpg

ASKER

oooh nooo!!! bad saving.. agnrgy windowze..won't let me save now.. make
stupid system32 textfile
saveProb.jpg
systemTxt.jpg

ASKER

nooooo! not stupid cancle!! this disaster bad wrong bad wrong wrong bad bad bad rowong
worong wong wong wrong wrong
cancel.jpg

ASKER

THIS LAST STRAW DISASTER NONSENSE> HOW TO DROP DANG TABLES??
exErr.jpg

You are hilarious. I have no idea where you are now, sorry. What can I do to help. I thought you had it there but it seems you and your database are not on good terms?

ASKER

Did I do the FK right?

ASKER

Okay I guess it's fine. Now how do I populate the tables?

ASKER

I got this stupid thing called Power Shell.. maybe that's where I type SQL? I don't want to lookup nonsense.Where is stupid spreadsheet type view of data in fields?
powerShell.jpg

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

It's not Open table. It's Edit top 200 lines..

allrighty then. I guess that'll do it. Thank you, sir.