I am back to working in FMP after a multi-year hiatus, and I am rusty and am currently stuck. Hoping someone can point me in the right direction. I hope I am posting in the right topic.
I am building a solution where we have a number of many-to-many relationships that are being used via portals.
This is the issue that I am having that I am stumped on.
In this instance I have the following db graph:
Workshops <--=--> WorkshopStaff <--=--> Staff
Each workshops may have multiple Staff and Staff may participate in Multiple workshops
On the Workshops layout I have a portal to WorkshopsStaff
In order to add Staff to the Workshop I have a button that brings up a popover with a portal that lists all Staff from which to select. I can select a Staff Member and they get added to the WorkshopStaff table.
This popover was more or less modeled on the "invoices" starter solution
The way I am displaying the portal inside the popover is via a table occurrence like this:
Staff <--X--> StaffList (Cartesian relationship)
My issue is that the portal in the popover (the result of the cartesian relationship) displays and works as intended as long as I have one related entry in the WorkshopClient table.
But for a new Workshop for which I don't yet have any entries in the WorkshopClient table the portal in my popover comes up empty.
What I am doing wrong or is there a better way to populate the list from which to select staff?
Thanks a bunch.
By Karlos Fandango
My database has only three tables...
ITEMS - Which is an inventory of tools for the company.
• BOOKED - Which records an audit of each time each item is booked in or out of the stores
• TESTED - Which records an audit of each time an electrical tool is PAT tested [safe to use]
The individual Items are displayed in a list layout called 'Item List' which is basically the 'Home Page'.
The BOOKED events are displayed in a portal in a 'form layout' called 'Item Booking'. I've set the sort order in the portal to show the last 'booking' at the top. The easiest way to this portal is to click the small blue "go" icon in record on the "Item Bookings" layout.
What I have tried to do is display the last "booking location" from the portal [at the top] in the 'Item List] so that at we can see the item's current location without having to view the portal each and every time. I managed to display the latest Booking Primary Key - [Max ( Booked::Book_Pk )] - but couldn't get it to reveal where it was last booked too.
I shall spare you the list of things I have tried but before giving up completely thought to seek help here where I received helped before. Personally, I thought an auto entry by calculation would have been best but I just couldn't figure it out.
Please find the file attached.
Any help would greatly be appreciated.
I have FileMaker 13 on my Mac at home but V15 elsewhere, if you alter the file please export in V13 to spare me having to leave the house to open it up on the other computer [V15].
By Gunther Stern
I am so frustrated after two solid days of working on this really simple join table example. I am trying to create a little iphone application in which I can quickly track my homeless outreach contacts on the fly. I have been so frustrated. I made a lot of progress at one point by just deleting the portal and starting over. I attached two databases, test which works just the way it is supposed to. A simple widget model based on something I saw on youtube. and Client test which is my attempt. Test works fine. Client test is very similar with a couple of extra fields including a calculated full name field but nothing significantly different. Right now the problem is the relationship will not create a new record in the join table. Maybe I don't even need a join table. Not sure but the join table was one of my attempts at a solution. I have been using filemaker since 6 but only sporadically. I used to be able to create simple solutions on the fly but I just spent the whole weekend trying to get this to work. I don't have any hair left to pull out! Help!
i have an event table and a coordinator table. Until now each event had only one coordinator. There has now become a need that at some large events require more coordinators - could be upto 5.
I have a login for the coordinators where they could see events which are assigned to them.
The relationship is that the cordinatorID in the coordinator table matches the coordinatorIDF in the event table.
I created a coordinator2IDF in the event table and tried to relate it aswell to the coordinator table but what happens that it even breaks the first relationship.
How could i modify my table it should work like that with my already created table which was until now a one to one relationship?
i would appreciate if someone could help me out on this...
By Nathan Wilcox
I've been trawling google and many forums for the last couple of days after numerous failed attempts, I'm now relying on the expertise of all of you. I currently have the following calculation:
IsEmpty ( Invoices::Search ) ; Invoices::Product Category Filter Popover = All Products | Popover::Category ;
All Products | Popover::Item ;
All Products | Popover::Supplier ;
All Products | Popover::Internal ID ;
All Products | Popover::Resale Price
) > 0
and Invoices::Product Category Filter Popover = All Products | Popover::Category
set up as a portal filter and it performs perfectly to what I needed when I was only testing with a few products in Inventory. I now have 36000+ records and would really like to only show items with a value of more than 0.
I found a suitable calculation (subbed in my own field) on filemaker:
If (All Products | Popover::Stock < 1; 0; 1)
But cannot find the right area to add to my above calculation.
Can anyone help???