Search results

Thanks much! -John

Thanks...that's a good first step. (For those who don't want to open the database, it shows a drop-down combo-box with (-1, unknown), (1, jan), (2, feb), ..., (12, dec) all listed; when I select one, the corresponding number (-1, 1, ..., 12) gets put into the Month field of Person.) It...

I have a table ("Person") with birth date information: month, day, year, all separate, because any one or more might be "unknown". I store "unknown" as a -1; for known values, I use a conventional encoding (jan = 1, feb = 2, etc.). I have a form for the "Person" table that lets me enter data...

Re: Design question: how to use a table to indicate "good" records from another table Nice suggestion, but not, in fact, appropriate in my context. In truth, the user will be messing with about 800 records, and may, while working on a record, say "THAT's one that I have to print later", and...

Design question: how to use a table to indicate "good" records from another table I need some help with database design/access implementation. Here's the simplified question: Main table ("Person"): ID <whcih is also the "key"> Name Address [lots of other fields] I'd like to print out the...