Search results

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...

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...