adding option to drop menu query

[NJBebop]

Hi all!

Quick (and prolly simple) question....

I have a drop menu running off a simple query. All I want to do is ad
another option within the drop menu within the specific form. i.e......

query option 1
query option 2
query option 3
None

With none being the addition to the drop menu since I obviosly don'
have (or want) a "None" record in the table.

I figure (or hope) that all I have to do is add the "None" to the quer
line i.e.....

SELECT DISTINCTROW option FROM options; "None";

I know this isn't how you do it (already tried). But is there an
simple way of adding this?

Any help would be greatly appreciated!

Thanks

 

[Duane Hookom]

If I understand correctly, you can use
SELECT option
FROM options
UNION
SELECT "None"
FROM options;

 

[NJBebop]

Hi Duane,

Thanks for the reply! This is VERY close to what I am looking for
however, when I try to use "None", it gives me the good ol' "relate
record is required..." message.

Here is basically what I am working with....

I made a database for my wife's aviary. I have a query listing th
pairs table as the parents for the babies in a drop down menu. So
basically have....

Parrots 1
Parrots 2
Canarys 1
Parakeets 1

that is pulled from the pairname field in the pairs table.

Since my wife also sells babies from another breeder, she has no recor
in the database for the pairs, so I need a "None" option in the abov
menu.

So all I really need is that one added text option in the menu withou
having to add a "None" record in the "pairname" field in the "pairs
table since it would be pointless to do so.

Thanks for your help!

 

[NJBebop]

Hi Duane,

Disregard my other message. I figured out the problem, ha
relationship set and it was preventing the "None" option from working.
I removed the relationship and it's working PERFECTLY now!

Thanks so much for your help!