thecowis40

Would I be right in saying that under this setup; one would not be able to create new records via a portal? How can one do this? Thanks again for the help.

Hi everyone, This has really stumped me. I have been thinking for a couple of weeks on how to solve this; and can't crack it. Essentially I am trying to setup a database for a customer (FMP11) for furniture. Pretty simple. One of the things they would like to have, is a related products section on the layout for each product. This would be a portal displaying all the furniture that is similar to the current item. The user would establish this relationship by adding the ID to the portal; and creating another 'similarity' relationship between the current product, and its similar brother/sister. This is where it gets interesting. The related product, is not multiple related records in another table; but rather related products in the same table. Pretty easy right? Just create a second occurrence of the table. That would work; but the problem is; I want these relationships to be mutual. What I want; is when I have products a b c d e f g h i, and I set a's related products as b d g h, when I go to the respective records for b d g h, and look in the related product portals, I would like to see a listed for each of them. I hope that's clear. I can imagine a way of doing it; which is defining a relationship to a table with recordID1 and RecordID2 and linking them to the primary table with a relationship "where ID = RecordID1 OR where ID =RecordID2" but Filemaker's flaw is that the relationship doesn't allow for the setting of OR for multi-criteria relationships, only AND. Any advice would be appreciated. I've toyed with repetitions and calculations... but no luck.

Hi all, Name's Adam, and am working on FMP 10 Adv to be implimented on FMP 10. Am building a database for student management for 4th year schooling. I have setup a layout for students that uses the tab interface. I have a script built into it. Problem - When I run the script (via a script trigger) it works fine, and pops up a new window as a part. The problem is, when the user closes the window, of their own will, the active window returns to the student interface (with the tabs) and seems to refresh the window as it becomes active (particularly when it is clicked). This wouldn't be a problem if it were a single layout, but as it is a tab interface, refreshing the layout defaults to the main tab of the layout, which is not the one that was left when the script was executed. Essentially the script is run to update information for a portal, and the effect is lost if the layout defaults to the default tab after editing. Would love to know what I have done to stuff this up! Let me know if I have left any details out. Am a first timer to FMP, and am enjoying it as a change to MS Access. Still learning!! Appreciate any help!