Rank: Newbie
Groups: Member
Joined: 8/2/2007
Posts: 1
Points: 0
Location: Liverpool
|
Hi. I am familiar with the concept of a relationship database and have created some using MS Access. I use MLA (myLittleAdmin (for SQL Server and MSDE) v.2.7 r.123) as part of my subscription with 1and1 web hosts and I use it in conjunction with MS FrontPage and it works really well. What is am trying to do is create a relationship database and i have created primary & foreign keys in 2 tables i wish to link. What I cannot do is see where the data is linked and if i change some data in one table how it is displayed in the other? What as I doing wrong?
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
You can check the relationships (foreign keys) in the table structure page, just after the Index section.
Hope this helps!
|