Greetings!
I'm using one form to display results from 2 diff tables, they are related by a serial #, and that # is set as primary key for both tables. I've got RI set so that the parent table should cascade any changes to the child table. However, when I go to add a record on the form, I can enter all the info for the parent table just fine...but I cant even click into the fields having to do with the child table. So I went ahead and saved the current record, when I went to browse the tables, the serial # had NOT been cascaded to the child table, so I couldn't even edit those fields on the form until I PUT a serial # into the child table. HEEEELP I know I'm just not thinking things through correctly, or missing some basic point here, but I'm not sure where to get started researching and looking things up to make this work...in other words, ANY assistance would help immensely!:)