https://www.infopathdev.com:443/forums/141.aspxQdabra is committed to answering InfoPath questions. However, we do not support Microsoft Access. For non-Access questions, please use the other boards.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/55679.aspxTue, 08 Jun 2010 15:41:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:55679Peekay0https://www.infopathdev.com:443/forums/thread/55679.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&PostID=55679Some Updates: I have managed to create my Equipement List based on the Norms. Using Conditional Style, I hide the equipements I Don&#39;t want to show ;) Now, gotta find out a good way to select them and store them.https://www.infopathdev.com:443/forums/thread/55646.aspxMon, 07 Jun 2010 19:48:10 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:55646Peekay0https://www.infopathdev.com:443/forums/thread/55646.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&PostID=55646Hi, <br /> <br /> I&#39;m having some problems with Access and Infopath...<br /> <br /> First of all, I am new to Access in general, but have done many Database in the past, mostly MySQL handled with PHP.<br /> <br /> What I Ultimately want to do, is generate a List of Items based on a relationship, being able to select Some of these items, and save them.<br /> <br /> With PHP, I&#39;d be done right about now, but Infopath/Access is giving me a lot of trouble.<br /> <br /> First of all, Here&#39;s a screen shot to my database, the relevant part anyways.<br /> <br /> http://img33.imageshack.us/img33/247/screenshotmw.png<br /> <br /> Some explanations since it&#39;s all over the place and it&#39;s weird.<br /> <br /> Essais (Test): What the form is for, we need to conduct tests and it&#39;s gonna be saved in there. <br /> Normes (Norms): It&#39;s like ISO and such, standardization stuff. Tests will have to respect those norms and use Equipments with the same norm.<br /> Equipement: List of equipments.<br /> EDIT: Norms/Tests right now is a 1-Many relationships for testing purposes :p<br /> <br /> Now, a Test can have many Norms, and Norms can be used in many tests.<br /> An Equipment can have many Norms and Norms can be used on many equipments<br /> <br /> The equipment list is about 500 items long, but 90% of it won&#39;t respect the norm. So filtering them by Norms would be ideal.<br /> This is the part where I Get stuck.<br /> <br /> I Can generate the list just fine, copy the right IDs into the Junction table (Sort of), But I Am unable to filter the list whats so ever.<br /> <br /> I&#39;m not really looking for a complete run down, but just some info to get me in the right direction. I Can&#39;t help but feel my hands tied so bad while working in Infopath, all of this can be accomplished with a simple Loop with a SELECT WHERE X=Y and parsing the results in a table with PHP, but unfortunatly, I have to work with Infopath.<br />