Bernie, Unless you need it desperately for performance, duplicating data in two tables is bad design. This is one example why.
-- Dennis McGrath mailto:[EMAIL PROTECTED] -- Full time consultant with SQL Resources mailto:[EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bernard Lis Sent: Saturday, July 20, 2002 5:26 PM To: [EMAIL PROTECTED] Subject: Re: What am I forgetting Thanks Buddy - another DUH for me. This is the second time I fell prey to this problem. I had a date field in both tables by the same name, they should have contained the same date - but!! ----- Original Message ----- From: Buddy Walker To: [EMAIL PROTECTED] Sent: Saturday, July 20, 2002 3:35 PM Subject: RE: What am I forgetting Bernie Do you have more than one common column in both tables.If so I believe that also have to match. Buddy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bernard Lis Sent: Saturday, July 20, 2002 2:41 PM To: [EMAIL PROTECTED] Subject: What am I forgetting Win 6.5++ 1.855 A 2 table form. I first created it with the detail table (RelDates) and created a region. I then added a header table (release). Edit using release where ponum = .pono The region fills in but no data in the header portion. When I [Shift][F8] I get "no editable data in this table". The field settings are set to add or change. This will probably result in a DUH but I have tried recreating this form several times. What am I forgetting to do? Bernie Lis Megabytes, Inc. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
