Have you selected "many to many" rather than "one to many"? I find that when I have >1 table on a form, I need the "many to many" If I am correct, "one to many" means that LineDetail has to link to the Header table directly, which I assume it does not. It links thru LineHeader, so there you need the "many"
Karen -----Original Message----- From: Bruce Chitiea <[email protected]> To: [email protected] <[email protected]> Sent: Sun, Sep 6, 2020 6:02 pm Subject: [RBASE-L] - Forms: Relational Fail #yiv0267676880 #yiv0267676880x60e28c9091074ff #yiv0267676880xce0a6bc6429748f68a1fbd60505e23fd, #yiv0267676880 #yiv0267676880x60e28c9091074ff #yiv0267676880xce0a6bc6429748f68a1fbd60505e23fd #yiv0267676880x0ffa9ca747a0444 #yiv0267676880x5341b55c703f4d708da1fcccafdd6cf1, #yiv0267676880 #yiv0267676880x60e28c9091074ff #yiv0267676880x86b4dd35dfc94ef5a5432fdb70f5f643{font-size:12pt;}#yiv0267676880 blockquote.yiv0267676880cite {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;}#yiv0267676880 blockquote.yiv0267676880cite2 {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;margin-top:3px;padding-top:0px;}#yiv0267676880 a img {border:0px;}#yiv0267676880 All: The issue: (1) In Edit Mode. As one scrolls through the values in the Header table, related values in the LineHeader table step right along, linked by the HeaderID FK value. Perfect. (2) The LineDetail table sits inert, as if completely dissociated from the LineHeader table, even though it contains FK LineHeaderID. (3) The LineDetail table may be scrolled independently of Header and LineHeader, scrolling neither. The Form's Table configuration:(A) The Form is Bound to the Header table(B) LineHeader is slaved (one to many) to Header via FK HeaderID(C) LineDetail is slaved (one to many) to LineHeader via FK LineHeaderID(D) It does not seem to matter whether the tables are linked via Common Columns, PK/FK or drag/drop. What have we checked? (a) All three tables have PK and FK keys properly defined, double, triple checked.(b) Data from all three tables have been linked, apart from this form, in Views used to produce Reports with gnarly Sub Reports, within a daily production context.(c) There are no "orphaned" rows from any table in the dataset used in the Form. Each LineDetail row links to a LineHeader row, which links to a Header row.(d) All column definitions in all tables have been closely scrutinized to ensure conformance(e) All tables have been UNLOAD/RELOADed into a spankin' new database to eliminate any random, unruly influences.(f) The above test Form was created to strip away any and all other Forms considerations. Any and all thoughts and experience most welcome. Stay cool in the heat, Bruce A. ChitieaSafeSectors, Inc.-----------------------------------112 Harvard Ave #272Claremont CA 91711-4716-----------------------------------rby...@safesectors.com-----------------------------------+011 (909) 238-9012 c+011 (909) 912-8678 f -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em5d0cc3c6-2d6f-4e6b-b46a-5f1a2d55a216%40pathfinder. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/46816626.1067437.1599485195630%40mail.yahoo.com.
