This topic is 2598 days old. Please don't post here. Open a new topic instead.
By Lea Alexander
I have 3 tables: Person, Session, and Contract where Contract is a join table.
I am in the Session table layout, in a Contract portal. I have a field – Trainer Name in the Contract table – where I want to select the name of a person from a list of people in the Person table. The Trainer Name field is a dropdown list using values from the Trainer value list “Person::__k_p_Person and Person::Name_Full”. I have tried numerous configurations with table instances and I either cannot alter the Trainer Name field at all, or I get a “?”.
After the Contract record is created, I want it to show up in a Contract portal on the person’s record in the Person table.
Each person will teach multiple sessions.
Each session has multiple trainers.
I have foreign keys in the Contract table for Person and Session.
Here is the scenario...
Contact table joined to Contact|Event table joined to Event table
Portal in Contact table of Event table to see all Events linked to a particular Contact
Needing to link 100 (or any number) of Contacts to 1 Event in Event table
Do not want to do this manually.
I have all the tables and relationships set up and everything works. All I need is a way to create multiple records (joint records in Contact|Event table) in multiple Contact records so I don't have to enter them in one by one...which of course I can do.
I figure this would be a script...but I don't even know where to call the script...in the Contact record? In the portal row? in the Event record? Where does the script button go? And what is the script? Once I create a found set in Contacts, how do I assign one Event to many contacts (in the found set) without having to enter the link manually.
Is there a difference in how Filemaker reads/acts on the two following Relationships:
1. Parent Table A --< Join Table AB >-- Parent Table B and
2. Parent Table B --< Join Table BA >-- Parent Table A ?
After my last disastrous foray into designing a Relationship Graph, I went back to the Filemaker Training Series to re-re-re-read about building correct ERDs and Relationship Graphs, but only managed to confuse myself even more. The FTS examples all use the Anchor and Buoy concept, but seem to have a huge amount of unnecessary repetition, unless I'm completely off base. Using their "04_Bonsai" Relationship Graph as an example, they have one Anchor-Buoy set of
ORDER --< order_LINEITEM >-- order_lineitem_PRODUCT and another Anchor-Buoy set of
PRODUCT --< product_LINEITEM >-- product_lineitem_ORDER.
These seem functionally IDENTICAL to me - you can even swap the icons around so the ORDER TO is on the left, the LINEITEM TO is in the middle, and the PRODUCT TO is on the right for both sets without changing the Relationships between them (and yet a third set with LINEITEM on the left and both lineitem_ORDER and lineitem_PRODUCT to it's right, which can be manipulated to match the above two sets as well).
If i'm sitting on a record in the ORDER TO, looking through the LINEITEM TO into the PRODUCT TO, does it matter if I have to look left or have to look right? Or are they just adding a bunch of Anchor-Buoy sets on the Graph to, ummmm, "clarify" process flows? Are there any performance issues in eliminating the redundant TOs? Is it considered a Best Practice to place a TO on the left of the Graph for every Table and delineate Relationships to the right of each beginning TO?04_Bonsai Relationship Graph.pdf
I have included a screenshot of the Relationship Graph (squished to fit) to illustrate my problem and, as always, your insights are greatly appreciated.
I am building a digital asset manager in FM 13 for Windows. I am having problems displaying filtered data in a portal. I have series of scripts that bulk imports the file names & folder structure and creates a collapsible hierarchical keyword structure that is comparable to the folder structure. It creates all the joins between keywords and assets.
When "Fiat" is clicked, all assets associated with this path are shown in a second "Asset" portal using the filter:
not IsEmpty ( FilterValues ( Data for Keywords::ID ; global::gCurrent Keyword ) )
This portion works fine. User added keywords are intended to appear in the same keyword portal using the structure of:
c: (imported example above)
------User Added keyword (ie Fiat)
A script inserts the user created keyword alphabetically into the keyword hierarchy and creates the join table record. This is where the problem occurs. Clicking on the user keyword in the keyword portal returns an empty asset portal. I have double checked all PK values in the asset and keyword tables against the matching join table records and they are correct. I have also manually deleted and inserted working and no-working join link records to see if there is an issue with how the joins are created (manually vs script) without affect.
Any suggestions on why this may be occurring would be greatly appreciated.
Who Viewed the Topic1 member has viewed this topic:vinnygi