Hi,
I'm having some problems with Access and Infopath...
First of all, I am new to Access in general, but have done many Database in the past, mostly MySQL handled with PHP.
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.
With PHP, I'd be done right about now, but Infopath/Access is giving me a lot of trouble.
First of all, Here's a screen shot to my database, the relevant part anyways.
http://img33.imageshack.us/img33/247/screenshotmw.png
Some explanations since it's all over the place and it's weird.
Essais (Test): What the form is for, we need to conduct tests and it's gonna be saved in there.
Normes (Norms): It's like ISO and such, standardization stuff. Tests will have to respect those norms and use Equipments with the same norm.
Equipement: List of equipments.
EDIT: Norms/Tests right now is a 1-Many relationships for testing purposes :p
Now, a Test can have many Norms, and Norms can be used in many tests.
An Equipment can have many Norms and Norms can be used on many equipments
The equipment list is about 500 items long, but 90% of it won't respect the norm. So filtering them by Norms would be ideal.
This is the part where I Get stuck.
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.
I'm not really looking for a complete run down, but just some info to get me in the right direction. I Can'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.