Reply to thread

Message: [QUOTE="John W. Vinson, post: 2598852"] Does your child table have three *FIELDS*? or three *RECORDS*? There's an old saying: "fields are expensive, records are cheap". If you have three fields your table design is probably incorrect. Could you please explain a bit more about the real-life situation? What kind of Entities do the two tables represent? Does each Parent record have many Child records? Does each Child record potentially relate to multiple (three? up to three? maybe more?) Parent records? -- John W. Vinson [MVP] Microsoft's replacements for these newsgroups: [URL]http://social.msdn.microsoft.com/Forums/en-US/accessdev/[/URL] [URL]http://social.answers.microsoft.com/Forums/en-US/addbuz/[/URL] and see also [URL]http://www.utteraccess.com[/URL] [/QUOTE]