i have 3 Tables Property , Units , Tenant.
Each property has many units , Each unit has one tenant active but may have many inactive tenants from previous years.
All working fine BUT.....
i would need to show a table in the property layout of the units and each one only with its active tenant.
The portal is based on the units table.
However the tenant just show up the tenant that was first input to the unit.
My question is , how could i get that only the active tenant should show to the unit?
i would really appreciate it someone could guide me on this.
Wondering whether this is one of Filemakers limitation and/or there are any ways round it.
i have a portal which displays my related records to a customer . These records are split down to two sections (Two options) i had created a slider that on slide 1 it displays option 1 and on slide two option two.
However the slider only seams to show up on the top portal row.
i would appreciate if anyone could explain me if this is not possible or something was just set out wrong.
I know I've done this before, but can't find an example of the functionality in my archives and can't seem to work out how to do it again.
I've got two tables: PERSONS and CONNECTIONS. PERSONS has an `id` field and CONNECTIONS has `person_1_id` and `person_2_id`. There's a relationship from PERSONS to CONNECTIONS with `id` = `person_1_id` and from CONNECTIONS to another TO into PERSONS, connections_PERSONS, with `person_2_id` = `id`, but these relationships may need to change to make this work.
On a layout with a context of PERSONS, I need a portal into CONNECTIONS that shows the names of the person on the other side of the relationship. So if Bill and Ted are connected, when viewing Bill's record I see Ted in the portal and when viewing Ted's record I see Bil's record.
So I have a hosted solution, with a dashboard with a couple portals. When I go to scroll a portal, scrolling even one portal screen has a delay of a few seconds, ie I click the scroll bar or try to drag it, and it takes about 3 seconds before it moves. Running locally, it's instantaneous. Running on a dev server on my LAN, there's a slight delay, but minimal.
Having read various threads about this situation, my first thought was it's due to a filtered portal, so I removed filtering, but that made no difference.
I also read various posts about unstored calcs and other factors that would cause all the data to have to be transferred to the client over the WAN.
But here's the thing - at the moment, there are about 20 records in the database, related to the particular portal.
Clearly, moving that data can't be the primary issue - right?
I do have a lot of Execute SQL calculations in related tables, and I've read that can cause poor performance. But wouldn't that only be a factor when there are a lot of records?
Are there design /schema choices that would cause significant lag regardless of the amount of data?
Hi, I am using this calculation in portal which calculates days in portal Date - (GetNthRecord ( Date ; Get ( RecordNumber ) - 1 ) )
how can i modify or do something else to avoid (?) in the first row. Sample file attached for any modification/help.
Thanks for any help
Who Viewed the Topic1 member has viewed this topic:hutchlad