MS SQL Server 2008 doesn't like my inputs

I'm trying to input values into my Microsoft SQL Server 2008 and it is making red exclaims at
me and my data goes bye bye
byeByeData.jpg
kayveyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sm394Commented:
if there is any foreign key field in that table make sure its reference else hit enter after input
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
the exclamation mark is "NOT" the problem.
please show the error you get, and the table structure, and any triggers you might have on the table.
0
kayveyAuthor Commented:
All these *@#& widget ding dangs are driving me crazy.  I'm not 100% sure where to find what you are talking about, but I was trying to make a few FK/PK relationships.  The red exclams are on fields that I didn't think I create such things.  Here I show you a second table, that should be at the top of the tree
or whatever, no FK problems  Automobile is linked to Customer by purchased_by which
is equal to PK license in Customer.  It doesn't seem to like my Customer either.  I also made a Sales_Rep I need PSmith I haven't created him yet, but I don't know why that should affect Customer
custCranky.jpg
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

kayveyAuthor Commented:
There are no errors in this error window
errorsEmpty.jpg
0
kayveyAuthor Commented:
Everything disappears when I press exclam "execute SQL"
0
kayveyAuthor Commented:
here is another file
PSmithThere.jpg
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>when I press exclam "execute SQL"

THAT explains it.
that button will return the SELECT * FROM TABLENAME ... and putting to the trash you input.
instead, just click anywhere outside the row, or for example "key down", and it will run the INSERT/UPDATE instead
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kayveyAuthor Commented:
0
kayveyAuthor Commented:
stoopid windoze craziness
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you must know that I have done that error in the beginning also ... :)
glad I could help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.