Hi,
I am an access newbie and wanted to get a design check to see if I
have done the right thing or if there is a better way.
I don't like the Yes/No field option in a table. I want to have the
actual Yes or No data in a text box. To accomplish this, I created a
new table with one field. There are just two records in the table,
Yes and No. I build a Drop Down box control on a form, linked it to
this new table, and everything works just fine. I can see the Yes or
No options and when I select one or the other, the data is properly
entered in my main database table.
So, this works...but is it good database design?
I heard that lookupfields are bad (Access MVPs -- your site is
great!). I didn't accidentally create a lookupfield, did I? I should
be able to sort by this Yes/No field just fine, right?
Thanks!
Zack