I am creating a simple invoicing system in which the contact_fk is a drop-down menu of a value list created from the related contact table. In the contact table I have radio buttons that say "Yes" or "No" regarding if the contact is a customer or not. I have also included two calculations, the first being If ( CustList = "Yes"; ContactSerNum_pk; "" ) and the second being If ( CustList = "Yes"; Customer; ""). These are the two fields I want to use for my value list in the invoicing system.

Here is my problem. What I WANT is a value list with the contactSerNum_pk as the first field and the Customer as the second field, sorted by Customer. For some reason FileMaker won't let me do this and only shows one contact. If I switch which field is the first and the second it gives me different results. The ONLY combination that gives me all the records that are valid is having the Customer first and the ContactSerNum_pk second sorted by ContactSerNum_pk. Why am I getting different results? Is it something to do with indexing?

Any advice/suggestions would be greatly appreciated! I am pulling my hair out on this..

Try it this way?

Filter_Active.zip

Edited November 17, 200817 yr by Guest

I'm sorry - what way is that? I didn't see anything else in your reply.

I dont know why it didnt attach earlier. I know that I had attached it. Try again.