[dba-SQLServer] Linking Tables(?)

If it's an A2K front end, linked to SQL Server, you can edit the table 
properties of the linked table in your FE to use a combo box lookup, just as 
you can with an Access table.

 On 27 Jun 2008 at 9:53, Darryl Collins wrote:

> 
> Thanks Susan and Liz,
> 
> Due to client restrictions (and they are a massive client - no wriggle room on this) it is SQL Server 2000 backend and Access 2000 Front End.
> 
> I can live with ID numbers only - At least I now not to dig too hard to find a 'solution' when there isn't one.  I am sure this will be the first of 1001
> questions I have on this.  Thanks for your time and patience.
> 
> regards
> Darryl.
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Susan
> Harkins
> Sent: Thursday, 26 June 2008 10:45 PM
> To: Discussion concerning MS SQL Server
> Subject: Re: [dba-SQLServer] Linking Tables(?)
> 
> 
> FWIW, VB Express is free and easy to use and depending on your needs, might 
> be a better choice for gui than Access.
> 
> Susan H.
> 
> 
> >
> > 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.
> 
> _______________________________________________
> 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.
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>