Unanswered: Question about entering data through form
I ahve a question that may be easily answered.
I have a main project table that is connected to another table. lets say one table project the other table customers..
table 1 is joined to table 2 with a many to 1 relationship.. 1 customer can have many projects.. table 1 having PK and 2 FK
if I wanted my first form to be my project table.. how could I fill the info out and then creat a new record without physically entering in the customer FK in prior.. I tried the cascade update.. however I dont think I get it...