Help with Data Access

[fireblade72]

Hi
Pretty new to access so hope these aren't daft questions!

I've got a table of documents, linked to 2 different tables which relate whether the document is a trial document (yes/no) and what cancer site it refers to (a list of 10 options). I need to be able to give users via a form the initial option of choosing to list a set of documents based on whether they are in a trial or not and also filtered by cancer site.

I've got stuck with trying to do this. I've been able to provide a form with a subtable that shows a list of documents by cancer type (by using a combo box), but I don't know how to further filter the list so that users can also filter by trial status.

Also another silly question - Within my table design for the documents, i use the old trick of setting up cancerid field to show the actual cancer name, not the number. However when I try this for trialid, which is a tickbox, it displays -1 or 0 not a yes/no option.

any help would be great. Thanks Jon

 

[The_Doc_Man]

1. For the "further filter" part of your question, search this forum for the topic "Cascading Combo Boxes"

2. For the "check box" part of your question, your problem is that a check box is based on a "derived" rather than a "native" field type. A Yes/No field is a "cast" of a byte integer field for which only two values are recognized. Therefore, if you use automatic formatting, you get the default for a byte integer field - which gives you values you report.

Look at using IIF for formatting an output field to show Yes/No if you want a non-integer output. Something like

IIF([myyesnofield],"YES","NO")

 

[fireblade72]

thanks for your help