Virtually combine two rows for dropdown

[squirrly]

Not sure what I'm looking for to make this work. I have three rows in a relational database table:


1 lost
2 found
3 sighted

The goal is to output LOST and FOUND from a dropdown list, with sighted items listed under FOUND.

So I need to virtually combine found and sighted, but can't literally combine them as they are used separately elsewhere. Am thinking I need to either manipulate the dropdown list, or use additional SQL in the main table outputting the data. Probably the latter, just can't put my finger on it.

I'm sure this is simple, but my mind goes blank if I am away from this for awhile and then work on it too hard.

[June7]

You have records that are coded as "Lost", "Found", or "Sighted" but you want the Found and Sighted records to be treated as one group?

[squirrly]

Yeah, I know it sounds bizarre. But I've done this successfully with another table using DISTINCT with another column, like this:

1 Male....................M
2 Female.................F
3 Male, neut............M
4 Female, spayed.....F

The dropdown lists M and F, which then pulls all consolidated records accordingly. This approach isn't working with this other table. However, the query for the gender table is significantly different with JOINs and parameters.

I just need to think about this further and figure out exactly what I'm asking the query to do for me and what tables the query involves for proper output. It sounds much simpler than it is!

[squirrly]

I worked it all out. Just had to logically manipulate the SQL in the table for the dropdown and the big table where the data was being pulled from.