Menu
Access has something like this where you view all the relationships between the existing tables, displayed as lines connecting them: keys, 1 to many, etc. I can't find anything in ss2008 - I'm very new to it on top of that. Any help would be appreciated.
516
Right-click a table diagram, and then click Create Relationship. The Create Relationship dialog box opens. If the table is from a relational database, a column is preselected. If no column is preselected, choose one from the table that contains the data that will be used to correlate the rows in each table.
open up the database folder for the database that you are interested in, click on database diagram, click on yes when a confirmation box pops up
right click on database diagrams and select new database diagram
Pick all the tables you want, click add and a diagram will be created
Now you can save the diagram, give it a useful name and it will be available next time you want to look at it
85
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
