pctechtv

But is there a way to get the original location of the file you drag and drop into the global field? Thanks

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

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

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 Windows. I tried it on FileMaker 12 as well it does the same. I know that $Path is correct, because before it gets to the insert I use the Data Viewer and it is correct, but when the insert attempts to happen I get the error (message box 1). Then I started playing with the idea of prefixing it with the examples in the dialog box and eventually it reads what is supposed to but still does not insert the file (message box 2). Thanks for any help. http://pctechtv.com/show/cantinsertfile.png

That helps too. Thanks

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!

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

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

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

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

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 around it. You could also look at it like who do you want to be your child. When Information is created this relationships gives us the ability to have as many Topics and Subtopics(Topics of Topics) as we want. Now I am not doubting what you are saying, but the way we are designing our database is like this. When a new record is created it is the Information, to create a Topic for that Information we have the mechanism via Scripting and other ways that creates a record in the TOPICLIST table which deems it Information with a parent. Now this is a Topic, the only records in our INFORMATION table that are not Topics are the (and I need a good word for this) root Information records. So this question, the Custom Function and the need for recursive ExecuteSQL help us always determine who is the root of our Topics. This is useful for many things, one being so that we can make sure a Topic can always be part of a found set that is its "Subject Matter" respectively. You point is a good one because understanding the type of relationship I am working with I have wondered if a dual parent could accidentally be created and throw things off. I would imagine yes, and say that there is a level of proficiency that need to be achieved with FileMaker that can be the sentinel for his not occurring. So I will consider your discussion good advice as well. Thanks

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.

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

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 is true I would think that this can be done with my function Infobase(). Eventually the “empty” of the result could insure we are at the highest parent. In my attempt to create a recursive Custom Function I must be doing something wrong?

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 show those records based on the selection of that topic but I am lost how to set that up. This was a script I setup to deduce the members of a Information set Set Variable [ $children; Value:getChildren ( INFORMATION::_kp_information_id) ] Set Variable [ $i; Value:0 ] Set Variable [ $j; Value:0 ] Loop Set Variable [ $i; Value:$i + 1 ] If [ $i > ValueCount($children) ] Set Variable [ $i; Value: 1 ] Set Variable [ $j; Value:$j + 1 ] Set Variable [ $children; Value:getChildren(GetValue(INFORMATION::listall; $j)) ] End If Exit Loop If [ $i > ValueCount($children) ] Set Field [ INFORMATION::listall ; INFORMATION::listall & GetValue($children; $i) & "¶" ] End Loop I am also lost how this list would filter a relationship to only see the members it produces. I am thinking I would have to make a script trigger run it on record entering. I don't know if this is an advised way, or is just plain silly. I am working on other ways to produce the members i want in an Information set via a relationship or a calculation. really lost with this level of relationships. As time passes I keep understanding more.