> I've got some elaborate joins I'm performing against tables > with which I'm not all that familiar. Access has a built in > function called Relationships which allows you to visualize > tables and their columns. Does SQL Server have something like > this?
Yes, look for Diagrams. You will have to create one or more diagrams to use this. > Alternately, is there a quick way of dumping a few tables (just the > structure) from SQL Server into Access so that I can use the > relationships tool there? Yes, as Ben mentioned, Access Projects can be used as front-ends to SQL Server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
