Darryl Collins
Darryl.Collins at coles.com.au
Thu Jun 26 01:59:58 CDT 2008
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. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller Sent: Tuesday, 24 June 2008 8:14 PM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] Index Fragmentation I've been investigating too. I will be interested to see what our investigations uncover. A. On Mon, Jun 23, 2008 at 6:30 PM, Francisco Tapia <fhtapia at gmail.com> wrote: > Hey Arthur, > I'm not ignoring your post, but have gone out to do some re-search in > between my normal tasks :). I'll let you know what I find. > > -- > Francisco > _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material. This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material.