Search results

I broke the tables up to follow data normalization rules. I have a lot of contingent data, and so didn't want to waste space with needless blank fields. For example, there are different sets of data that would be filled in for each employee based on what role they perform. I didn't want to...

I am grateful to find this thread, because I am having the exact same problem with my Access 2003 database. I changed my form's control source to a query containing my main table and related tables, but when I do that, the form appears blank, presumably because of the 1-to-1 relationship...