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
I have developed an work order intake form on Web direct. The problem I'm having is that some users can't see a portal I have to enter certain information. Whereas most users do not have this problem. This is occurring on window users using Chrome. I am using FMP 16 and Server 16.
Does anyone has any idea why this is occurring. Is this a chrome or windows problem?
By Haris Durrani
Assalam u aliqum dear Brothers
I am creating a database for a Bricks Kilns. Though me being a beginner i have managed to make it somewhow but now i am stuck in making a portal of customers where i enter bills and the record should go tot heir related filed.
I have following tables
Customers (linked to with foreign key)
Challan (further liked to)
The portal shows only one customer related record
where as i want a portal where when i cretae record it goes automatically to related customer record.
Sample file is attached