filemorf

Thanks

Hoping that version 8 addressed FM lack of ability to name the file while exporting the contents of a field by using a field value. rather than relying on OS scripting or plug-ins Anyone know if this has been upgraded ? Thanks, filemorf

Well this answers my question, but I am very disapointed, that to use a field value to name the export value i would have to call and os level script then use activeX automation to call back into filemaker to get the filename. I wonder if this has been adressed in version 8?

I am searching the forums now to do the same, I would like to have my exported containers filename = 2 fields combined, the specify button does not seem to let you type in anything other than a file reference where I thing I would want a calulation.

I can also export the container fields contents but rather than asking the users I would like to use the contents of 2 fields to create the file name, the specify button only lets you enter file references I would like to use a calulation to create the name. Is this possible?

Last night I went searching through the help file script reference as I thought in the past I seen function that allowed me to enumerate through the meta data of FM's tables. Since I must have been seeing things and then I thought about that I still do not have any functions that would allow me to create fields at the script level. I am not finding much joy in my search results here and elswhere it is time just to give in and copy the schema by the eye to hand method. Though I imagine by tomorrow I will be ready to spend money on third party tool

No , not upset. I did search around, though now I know too keep looking. Thank You. I would have to say the Filemaker community has always proven to be friendly and helpful. Please forgive an negative tone that I may have implied. If anyone has a link to the thread or 3rd party tools that would be great too. Dave

Well was not expecting 20 views and no replies. Is my question so basic that it is insulting? I have just started to use FM again after leaving it a few years back for other systems. I am lucky enough to have noticed FM7's release and tried it out. Anyway now I creating an application with for a customer, just decided to integrate mine with FM Inc.'s sample app 'Business Tracker'. I have figured out all I need in the business tracker to add modules and security now I just need to copy my table schema from the DB I started in to the copy of the business tracker I have made. In the endless saga to compare Filemaker with other products, systems like access and SQL have ways of exporting the schema and copying tables structure, with or without the data. So again I pose the question, can Filemaker 7 export or otherwise allow me to create a new table using the schema from another FM DB?

First off sorry if this post is in wrong place, all the topics in database schema section seem to specific. I Would like to know if it is possible to copy a tables schema from one database.fm7 to another? David

This is interesting, I did not know that run time apps have the limit of being stand-alone. Though does this also mean single user? only one user at a time can open the FM runtime file at a time? Also what is the format of a FM run time application, just a single executable, portable directory or something that has to be installed? Thank You, David

yeah I been draging over the area to get all selected and then sending items to the back one at a time. I am sure you are not making this up, so I will keep poking at it. ---UPDATE--- it took all of about 1 minute to find when you reminded me i have to click the edge. Thank you, David

Detlev, Soon as I read your reply I though to myself, yeah sounds just like the horizontal portal example I just seen on another web site. I did not know that about portal display behavior. I rushed right to the Business Tracker example ungrouped one of the tabs, I could not find any portal. Is there any way you can guide me in closer? I just must be missing something here. David

I have been learning Filemaker via the Business Tracker solution/sample, I have a strong DB back ground and understand the tables and relations specific to my question. What I would like to learn is how the location tabs are able to display data from up to 4 rows from table having a 1 to many relation without the use of a portal? Layout name 'Company Detail (Contacts)' use table 'Company' and has 4 buttons on it bound to field location::namedisplay, this field is of type calc using a case function and to the best of my understanding will always be true. TextColor( Case(UserSelectedLocation::UserName = Get(AccountName); TextStyleAdd ( Name ; Bold ); TextStyleAdd ( Name ; Plain )); RGB( 255; 255; 255)) The table UserSelectedLocation is linked into customer just like location is, this table only gets a single record created for user + company ID. review: 1. company starts it all and is the default for the layout. 2. can have up to 4 locations for each company in the 'location' table. 3. the 'UserSelectedLocation' table will only have one record for each user that has viewed a company. 4. the 4 fields on the layout, linked to the same same field in the table are not in a portal. When I duplicate this setup in a new db I just get the same first record in all my fields, I will have to admit that I did not create a matching UserSelectedLocation table and my calculation field was just pointing to the name field. I have done this short cut here as I tested in the business tracker app by deleting the record in UserSelectedLocation then switching back to the company detail view, I get the results I expect, the fields to edit the current location are blank as no record is there to pick a relation. The 3 field creating the tabs are still there and they match the 3 location records I have in the location table. Soon as I do something that cause the record to be recreated the location data returns. Also in the business tracker solution the fields are not displayed unless there is a location record for it, i know they have to be setting the color but cannot find out where. Thank You, David

I am working through the example.fm7 to learn how to make a "magnifying glass" portal. I have noticed that the find features built into FM no longer work. I am making the assumption that it is because my default table for the layout is now main and not vehicle. Also the fields are now pointed to vehicle2 the second instance of the vehicle table on the graph. Do I need to script some extra stuff to find now?