[dba-SQLServer] Linking Tables(?)

Welcome, Darryl.

You will find that there is nothing so form-like and user-friendly
available in SQL Server.   If Table1 has got numeric ID fields in it, it
just has numeric ID fields in it, and you won't be able to hide this.
You can link your tables to your old friend Access and use that as a
front-end for nice GUIs, but SQL Server is about storage--relatively
large storage--and nothing else.  No GUIs to be had.  

Having come from a Access background myself, this was hard to accept.
But with massive help from Books on Line (SQL Server Help) and this
list, you will find it will all come together in time.  

Good luck, and have fun!


Liz   


Liz Doering 
Systems Engineer
Technology Information Group
elizabeth.j.doering at wellsfargo.com
 

 
 
This message may contain confidential and/or privileged information. If
you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose, or take any action based on
this message or any information herein. If you have received this
message in error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.



-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Darryl
Collins
Sent: Thursday, June 26, 2008 2:00 AM
To: Discussion concerning MS SQL Server
Subject: [dba-SQLServer] Linking Tables(?)



Hi everyone.

This is my first week into a new world (well new for me) of SQL Server
2000 and my first post here.  Quick background.  This list was
recommended by the folks on AccessD (some names here I already
recognise).  My background is primarily Excel, VBA and more recently MS
Access.  I now have to learn SQL Server for work so fun days ahead going
back to being the new kid in the class - I will apologise now for asking
some pretty basic questions from time to time.

ok.. Here is the issue I have now.

I have Table1 which is made up of

Table1keyID (primary key)
Table2KeyID (FK)
Table3KeyID (FK)

Table2 data
1 Alpha
2 beta
3 delta

Table3 data
1 Blue
2 Red
3 Green


Table1 desired outcome

1 Alpha Blue
2 Alpha Green
3 Alpha Red
4 beta Blue
5 delta Red

anyway.. you get the idea.  In Access I could make the Table2 and 3
KeyID fields a drop down combo box, set the number of visible columns -
that sort of thing.

Now in SQL i have created the relationship between Table1 and 2/3, but I
am trying to add data into table 1 and I want it restricted only to data
from Table2 and 3 respectively - I liked the combo drop down
functionality in Access in the table itself.

What is the best (or correct) way to do this in a SQL table?

I hope that is clear.

Regards
Darryl.