Re: [Q]Problem with master-detail forms

Idea:
I bet you have a date as one of the fields linking the two tables. Forms treats dates very weird, in fact Oracle does, using time as well.  If you do have a date linking them, and you want to make sure the master & detail are the same date but not time, then change the datatype of the fields from DATETIME to DATE.
Keep your fingers crossed!
janet

MCC wrote:
>
> I wonder if anyone has the same experience. I create a master-detail form
> using primary key and foreign key as the joint condition. Every thing
> is generated automatically by forms(triggers, relation) and work fine.
> Then I stared adding things to the form and something strange happened.
> My form will only pick up the detail records entered on the present day.
> Anything entered day before disappeared from the detail block and can not
> be queried either. Yes, the data are still in the table and I am able to
> pick them up using a different master-detail form. I did not touch the
> part that was generated by forms to handle the relation. I wonder what
> other thing that I could have done to break the link without knowing?
> Any idea???
>
> Thanks a lot,
> Edith
  Received on Tue Sep 10 1996 - 00:00:00 CEST