Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 One to many Relationship table design.

Author  Topic 

ramindya
Starting Member

5 Posts

Posted - 2012-02-10 : 14:25:58
I am attaching a sample application ( in the url) whose front end and back end database is MS ACCESS 2010. It works perfectly fine and I am getting the expected result. ( The database is MS access 2010 itself )

Issue: How to create similar table design in SQL Server so I am import or link it into MS ACCESS to obtain same expected result ?

Please review this url to download the
[url]http://www.dbforums.com/microsoft-access/1675537-one-many-relationship-pateint-visits.html#post6537733[/url]

Thanks in advance !! I hope somebody can help me with this issue.
   

- Advertisement -