Hi Folks, I have a table named “systems “ Systems is self-referential and has an ID field and a parentID field. I use a subform to display the list of subsystems a given system contains. In order to make this work, I have to tell dbforms that the parentID field is a “key” field as it is a foreign key.
I also have a table called “interfaces” each interface has a systemID field and I display a list of a system’s interfaces in a subform as well. There is a link to drill to a page with the specifics for each interface. When I am looking at an interface page I need to determine the “position” of the system that contains it. Although the systemID uniquely determines that system, I still need to provide that system’s “parentID” since it is a “key” field. The problem I have is that I don’t store this information in the interfaces table. Does the dbforms-config file differentiate between primary keys and foreign keys? Why should I need the parentID, which is a foreign key, in the position string to get to a given system? I have a foreign key specifier in dbforms-config, but it doesn’t help. Has anyone had any luck with this? Cheers, -Joe ------------------------------------------------------- This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput a projector? How fast can you ride your desk chair down the office luge track? If you want to score the big prize, get to know the little guy. Play to win an NEC 61" plasma display: http://www.necitguy.com/?r _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
