Help with DD would be appreciated.1.I have 3 tables:Table Notification notifid int Primary key TypeID int Foreign key to TypeID icon1 int Foreign key to iconID icon2 int foreign key to iconIDTable icon iconID int Primary key Link varchar(200)table NotificationType TypeID int Primary key description varchar(200)My ProbleM1.Trying to insert into 1 tables Notification.What would the Dbdchema look like? your help would be appreciated, we're able to insert into into a table with no foreign key, but as soon as we include foreign key, "Houston" we've got a problem?Regards,Michel
I've went thru the book Database Deployment for OpenDeploy admin guide 6.1, did a search on primary key's and foreign key's and none of them refer to my specific situation, the only thing that give me an ideal is the "Rules for creating dbSchema.cfg files" and even then it does give me to much, I'm doing a stand alone insert... should it be that difficult to retrieve this kind of info for my case...Regards,Michel
