I created a Many to Many relationship using two tables, Table 1 and table 2, connected through a Junction Table. I then create a Form and Subform for the relationship, which works. However, I noticed a null (0) value showing up the foreign keys of both Tables 1 and 2. is this normal? This makes me nervous and I am considering using Lookup Wizards instead. I know using Lookup Wizards is supposedly not good database design but having null Foreign key values doesn't seem like sound database design either. Any thoughts?