https://www.infopathdev.com:443/forums/43.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/22721.aspxWed, 29 Aug 2007 12:34:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:22721Clay Fox0https://www.infopathdev.com:443/forums/thread/22721.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=22721<p>First Best Practice is to look at using SQL Express instead of Access.</p> <p>So if I understand right, you have multiple secondary tables, which you need to link together by company or category or something.</p> <p>For this would would need to create this new Primary table or Identify an existing primary table and it would need an ID field which is a primary key.&nbsp; Then in each of your other table you would need to create a field to hold this primary key as well.&nbsp; This would be your relationship field to link a secondary row to the primary row.</p> <p>One optino would be to create a whole new table strucutre for your data and as you process your data move it into this new architecture.&nbsp; This culd be accomplished via InfoPath. Otherwise, you would need to go through all of your existing data first in Access or SQL and get it fixed then setup your InfoPath form to add new in the same relationships.&nbsp; InfoPath, database forms have to be setup as such from the beginning and are completely dependent on the existing table relationships, these have to be established and working for InfoPath to work, especially submit back to the database. You would not be able to perform table maintenance via a form, at least not without WebServices.</p> <p>You may want to look at the Database Accelerator, which includes a whole suite of web services for interacting with your database, but it requires SQL or SQLExpress.&nbsp; <a href="http://www.infopathdev.com/files/folders/dbxldownload/entry22386.aspx" target="_blank">Qdabra Database Accelerator Suite Version 2.1 - Developer</a></p> <p>Let me know if you need anything else.</p>https://www.infopathdev.com:443/forums/thread/22701.aspxTue, 28 Aug 2007 16:42:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:22701tcsqa_engineer0https://www.infopathdev.com:443/forums/thread/22701.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=22701<p>Hi All, </p> <p>I have a Access Database that stores large number of records. One of the new requirement that I got for this app is to allow establishing relationships between the records in the DB and any new record that is being added to the DB. I am using infopath form to add the records to the database.</p> <p>What specific control on the infopath form should I use to create this relationship.</p> <p>What specific control on the infopath form should I use to display this relationship.</p> <p>The relationship will be 1-Many.</p> <p>Thanks, </p> <p>&nbsp;</p>