Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About pctechtv

  • Rank

Recent Profile Visitors

1,633 profile views
  1. But is there a way to get the original location of the file you drag and drop into the global field? Thanks
  2. While creating a database that has Products, Suppliers and Lines I have come across the need to calculate a count of the suppliers from the context of a Products record. My relationship is like so: My question if I want to pull a lot of information about Supplier is should my portal in the Products record be from Suppliers or from Lines? If the best answer is Lines, could I still have a count of related Suppliers by using the primary key from that table in the portal? Is it a bad idea to use fields from a related tables portal other than its own? Thanks
  3. Seems to be that this format for the variable solved it: "filewin:/" & Substitute("G:JulimyMov2.veg";""; "/") which results in filewin:/G:/Juli/myMov2.veg Thanks
  4. I have a container field and I was trying to write a script to automate multiple file inserts. I noticed that I when I assign a result of a global field (in this form C:Apache24INSTALL.txt ) to where the file lives the dialog would pop up with an error that tells me that it could not find the file. The thing is that it was chopping the directory off of it every time (leaving off the drive letter). Currently to test it I am only trying to insert one file. After trying to get some help on the FileMaker forum I want to ask if anybody knows of this as a bug. I am using FileMaker 13 Advanced on Win
  5. It was your method that exposed it for me, I quickly solved it by creating another table occurrence and setting the ID = to the global you suggested and it works like a charm. Thanks!
  6. Yes I cant get it to refresh, but the grabbing the ID part was very helpful. I did not know that clicking on a portal row could give you the ID via a script. From here I should be able to figure something out. Thanks
  7. I have a portal on my layout that has about 5 rows, I have another portal from the same relationship next to it that is only 1 row displaying a picture(container). How can I get the 1 row portal to be in sync with the active row of the 5 row portal and show it corresponding picture. Do I need to separate table occurrences? Thanks
  8. Yes! I have been looking at it more and I get it now. I see what you are saying. That makes me understand the relationship a lot better. I have been doing some more studying and can see that I have been redoing a lot of the work that FileMaker already has done. Also this lets me see the power of the Found Set. In some training I have been using the instructor goes through a process of saving and restoring Found Sets. Can or should the members found set be stored as a variable or do you just have to collect the members (in this case ID's) into a list to do that? Thanks
  9. If that is the case and I am only complicating things I will change immediately. Will this be same as Information-----<Information_Topic>-----Topics------<Topic_SubTopic>--------SubTopics? TO's in green all have the same data source table, Topics. TO's in Blue all have the same join table as a data source table. Will this allow for unlimited Subtopics for a Topic? This will mean revamping a lot but if better I will get to immediately. Thanks
  10. This database is a collection of Information for the purpose of solving problems. For example Subject -< Problem -< Information. When we get to the information part it breaks into the relationship that is pictured. This was suggested to me, and when I understood how it would work I implemented. It is so simple but can seem so complex some of the time. Simple because it is just like your saying to a record "who do want to be your parent?" and we just give it the ID of that in the join table. New to FileMaker (about 4 months in) but not to programing it took me a while to wrap my head arou
  11. I received some help that that showed me what I was doing wrong and not understanding. It explained the Let function better so I see why my declaration and reference were getting me no where. This worked Let ( id = Infobase ( anid ) ; If ( IsEmpty ( id ) ; anid ; DuParent ( id ) ) // if )// let The Let variables only keep there value for as long as the Let Evaluates is what I learned and it is a great help.
  12. Excuse me for not being on top of the previously posted topics, I am all over the place devloping and being the lead hear at work on a bunch of open projects. I was under the thinking that related to or not, I should make post separate for the time that they were being dealt with. I see now that here I should probably include them and be more diligent in updating the info. The people on this forum have graciously responded to my questions and did their best for me. I say that because I should do my best to meet the requirement of the forum. I will do better. Thanks
  13. In my solution that is based on this type of relationship (pic) I have a custom function called Infobase(). What it does is let me deduce the parent of a particular Primary Key. I use it to do things like link Information Topics back to found sets. http://pctechtv.com/show/cus.png So I am imagining that I keep feeding the result of Infobase() back into itself that I can come up with the parent of all parents in a particular topic. I was looking into to recursion in Custom Function and saw some info that said a Custom Function cannot iterate but it can recursively call itself. Assuming that i
  14. Yes exactly I am speculating because I don't have enough experiance with complex relationships. I have a solution that is Information for solving problems basically I was thinking that it would make good sense to keep users in the subject matter. For example we have information we are storing for a setting for a piece of Computer Hardware so I would like to set it up where when in that information you only can see its Topics, Subtopics etc.There will be no neeed to see information about lighting for our video shoots. I was trying to work with the idea that a relationship could be used to only
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.