Hi

I found something kinda weird.

I have 2 tables with this relation, I also allow creation of records
with that relation

Table1 Table2
Code_tb1 = Code_tb2
Start_Date <= Date
End_Date >= Date

In a layout displaying Table1 data I have a portal of Table2 with the
Date field in it.

When Puting a range date (so I will only display data from that range
in the portal) in the start and end field and will add a new entry in
the portal a strange thing happen.... all record created with a DATE
in the range will be display.... that's right, but if I create a
record with a outside date, it will be display in the portal anyway
even if the criteria is not met.

#2 When going into a layout with Table2 field and manually enter a new
record with a date outside that range... and return to the Table1
layout..... it's not there and when changing the date range it will
display or not those manual entry.... but those done with the portal
are stuck there.

When looking a the data in Layout Table2, they look identical, it's
like something not hold in any field are making them appears in the
portal ?!?!

I try re-editing the relation between TB1 and TB2 and it's always
doing the same thing.

Now why i'm doing that.....
TB1 is contrat and TB2 is Contrat Maintenance visit and I want to keep
a back log of all the visit for that contrat, but only display those
between the start and begening of the current contrat.

as a work around ( and I'm tired of creating zillions of relations
just to patch some of the limitation of FM) I can create 2 relations,
one for display only (put I won't be able to edit those news dates
when renewal of the contrat, will have to make another layout...) but
the problem is that Table2 is linked to other Table and I need those
information somewhere else... so its table multiplication time !!

Can anyone confirm that problem, fix it (cause I'm not seeing it!) ?
or I contact FM and hope they will fix it by FM13 ?!?

thank you

Bizouman wrote:

I am unable to replicate your behavior.

When I create a new record through the portal by entering data into a
field other than code_tb2 or Date, it inserts Table 1's Start date as
the date in table 2. If I then manually change the date within the
portal to something outside the range, then it immediately disappears.

When I create a new record through the portal by entering an
out-of-range date into a blank portal row, it inserts Table 1's End date
as the date in table 2. If I then manually change the date within the
portal to something outside the range, then it immediately disappears.

So my questions for you: how are you creating the portal record? How
are you changing the date? What is the resulting date if you display it
in the portal?

Howard

Thank you, Sorry for the deay, I was away on vacation

The portal first entry is the date field, so that may be the cause.
When It's create it's there, in/out of the record still there, commit
record.... go into the date field, modify for another date still
outside the range, and now it's gone.

I try switch order in the portal and now the 1st entry field is not
the date, it's field_#2 and the date is the second entry.... when I
commit the record, it's no longer in the portal....

So I think it's defenitly a bug in the process

JF