web compatible query and relationship

[char]

I am creating a database in the web compatible format of Access.

I have two tables [Welds] and [Tests] ... Each test report contains around 6 welds which could pass or fail. I have done a look up in my [Tests] with a field name "passed" and a field named "failed" then selected from [Welds] which "Weld ID" has passed or failed in that particular test.
However I want to be able to then search by "weld ID" to see all the tests that have been done on that particular weld.
Does anyone know if this is possible and what route I should go down to do it?



Any suggestions would be greatly appreciated.

[June7]

Why have two fields? Why not one field with two possible values - P or F?

Should be possible in query that joins tables.

Want to provide latest version of your db? The one I previously downloaded does not have table Welds. That version shows storing passing and failing welds into multi-value fields of Test table. Have you changed the structure?

[char]

In the db I sent it is called [FBWelding]..
Basically one test looks at many different welds, them welds will appear in lots of different tests and could pass or fail the particular test. I want to be able to search a weld id and it then list all the associated tests.
Because it tests so many different welds I needed to select multiple values which passed and mutliple values which failed but this is making searching the welds very difficult.

[June7]

I don't use multi-value fields but then I have never built a web database.

If you want to filter/sort multi-value field data will need to create queries that expand the multi-value field data to separate records. Review:
http://office.microsoft.com/en-us/ac...001233722.aspx