This discussion is archived
8 Replies Latest reply: Nov 19, 2012 1:31 PM by MLBrown RSS

Master Detail form Can not insert Foreign Key

faisal niazi-2368916 Newbie
Currently Being Moderated
Hello,

I have Master detail form, in the Master Data Block I have Primary Key Header_ID and this is generated through trigger on the master table, and this field is in the data block but is hidden on the canvas , this Header_ID is foreign key in an other table, on form I have created the master detail form and also created the proper relationship. now when new record is inserted, the Header_ID in the master table is populated properly while in the detail table it is going as NULL. I dont have any idea how to resolve this issue, any help will be appreciated

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points