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.
By Richard Fincher
My production Filemaker Server 14 running on Mac OS X 10.11 El Capitan (Not Mac OS X Server) has been running fine for a year since I last installed the Thawte SSL Certificate. After renewing the certifate this year, I've tried various different methods of importing the new certificate, which came with an intermediate certificate, but I can't seem to get the intermediate certificate installed. I've been mostly using something like:
sudo fmsadmin certificate import --keyfile /Users/richardfincher/Desktop/GBROOMX36-4X/private.key /Users/richardfincher//Desktop/GBROOMX36-4X/ssl_certificate.crt
I've also tried importing it through the web control panel. It was necessary to remove the old private key thus.:
sudo rm /Library/FileMaker\ Server/CStore/serverKey.pem
After it is (apparently) installed, I usually restart with :
sudo fmsadmin restart adminserver
although a few times I have rebooted the server (not a VM)
Any thoughts welcome....
Oh, one thing is, a year ago it might have been still on Mac OS X 10.8.5 Mountain Lion, which was the previous OS before I upgraded it.
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.
By Qam Qam
hello every one
there is a way to send SMS without any plugins ,
there is a teacher named (guy setvens) who have course on udemy to explain it , problem is its paid , i i cant afford it
any one knows how to do it
i have bought 10000 SMS with api form sms provider
but i dont know how to use it without plugins