iNovice

I created a file path field so as to access my quicktime movies via the web viewer. I set the calculation to the filepath field and I'm getting nothing. Do these movies automatically load like a web page. Is there additional scripting required? Is there a sure way to determine whether you have the correct file path? Thanks for any suggestions.

I just learned how to relate the same table occurance allowing me to create a portal on a form layout within the same table, but after thinking about it I thought I had read somewhere that portals would not work in a web published enviroment. I started out with a separate list view layout and had a header containing a couple buttons, and then later read that the header would not work properly in a web published environment. If both of these things are true is there another approach to accomplishing my objective. I would prefer having a list type view contained on the same form layout if that is possible. Thanks for any suggestions.

Tell me it ain't so. Is it true that portals are not web compatible?

I guess I didn't understand the cartesian join concept, but after selecting that and changing it from the equijoin, all the records now show up in the portal. Thankyou.

Just noticed my post title is a typo. It is supposed to be self join portal.

I'm not sure this is the right terminology for what I'm trying to accomplish, but is a self join basically replicating a table occurance alowing me to relate to the same data in a different manner? Anyway, I guess I'm trying to accomplish what I think would be a many to many relationship within the same table, or in other words I want to see an individual record in form view as I select it from a portal containing all the records within the same table and on the same layout. Or is this doable?

Is there a way to capture a full web page within the web viewer,(even though the web viewer windows dimensions are too small to show the entire web page), save it as a PDF, and then insert it into a container field?

Is there a problem with having two unique primary keys in the same table and layout? I want to track two different types of customers in a single customer table rather than making two separate tables. Is this unusual and am I asking for problems? Thanks

OK, here's the deal. Time is of the essence and I need a crash course on getting all learned up on this Filemaker stuff. I need to move from novice to semi-pro in the shortest period of time. Obviously I'm looking for the best FM resource that can make the complex look easy, and at a reasonable cost. Online training with peronal consultation support if I got stumped would be ideal, but I realize I probably can't have my cake and eat it too. Any (I will not be disappointed) suggestions? Also, since most of what I'm trying to develop would be web published, an emphasis in that area would be most helpful. Thanks!

1. Do the tabs layout feature in FM 8 advanced work with a web published database? 2. Since I can't seem to get any help in controlling access to data within the FM desktop application, is there a simple and secure way of downloading record data from a web solution and then importing that data into a mirrored desktop solution? 3. If I want to publish online Quicktime video files within individual records, what are the most critical components in serving those files properly.. (memory), (CPU), (harddrive), or (bandwidth)? 4. Does the 100 simultaneous user limitation (FM Server 8 Advanced), apply to each database file or all database files being served on an individual server? I was told that 100 simultaneous users really means 50 unless it is used in conjunction with Xserve. Is this accurate? Is there a cost effective way of increasing the simultaneous user numbers? Thanks for any help or suggestions!

Will a Filemaker field except barcodes. If so how would the field be be formatted, text, number, container?

For those of us who are not yet expert I just discovered that all quicktime files are not equal. I created a quicktime file and put it into the container field I created but it would not open or play within the field. I went back and saw that there was a number of different options to save as a quicktime file. My original file had a suffix.dv which would play via the quicktime player if it were a referenced file. I went back and saved the movie under a simple quicktime movie file (which is what I thought I was doing initially), and it opens into the mini player inside the field and works nicely. Just in case someone else may not know.

Thank you! The second method you suggested seems to work as I had hoped. I can create a new customer record from a button in the business table taking me to the customer table and inserting the business ID on the customer side. I then dragged the customer ID and the customer status fields over from the customer table into the business table so that I will be able to determine whether the business is a customer based on whether they have a customer ID.

Why are my container fields grayed out in my relationship graph. Every other field is normal. Also when I put a quicktime video file into the container field it won't play unless I create a file reference. Anyone know whats going on?

I'm working on a runtime application. Whenever you make it a stand alone app can it contain data before the runtime process and if so will that data remain after the process is complete? In other words I want to create an ID for the runtime app coming from another related filemaker file, and then burn individual disks containing unique ID's for each app.

I tried doing a set field script but it's not working. I created an add customer button in the business table layout that I had hoped would allow me to create a customer record. I would first perform a find and locate the business record via a business ID primary key field search. After finding the matching record, I would click the add customer button which hopfully would take me to the customer layout, create a new record, insert the Business ID into the related Business ID field, (foreign key), and then go to the first Customer data input field establishing a related customer record. The following script is the one I'm trying, but no business ID is being set in the Business ID field of the Customer table layout. I do get to the Customer layout and it goes to the first field assigned with the blinking insertion point, but no ID is being inserted into the business ID field on the customer side. Any clues to what I'm doing wrong? Go to Layout (Customer) New Record/Request Set Field (CUSTOMER::business_id; BUSINESS::business_id) Go to Field (CUSTOMER:: name_first)

As a followup question, is there any Filemaker Guru's here that would know whether this is outside Filemakers capabilities?

I'm new here, so please forgive my double post. I will try again and hope that I'm descriptive enough so that it makes sense. I would like to control access to data either by way of the found set, or controling the printing of a found set utilizing some sort of key. I have 2 tables. 1 table, (business table), displays alot of static data, a primary key serial number ID tied to a specific business, and some other business information fields. The other table, (Prospect table), holds the mailing list data to be merged with the business table. I would like to control the access to the mailing list merge data by some sort of key to unlock a predetermined number of records with predetermined zip codes, and then revert back to secure after retrieving the found set or printing the found set. Any ideas?

But if this is a one to one relationship isn't it essentially 2 parent records, or at least as I understand it, parent equals the one side of the relationship and the child typically represents the many side of the relationship. What happens if they are both one sided and will always be one sided. The problem I'm facing is that I want to be able to delete a customer record without deleting the related business record. The only thing I can think of is possibly creating an (inactive customer) field where I can control the customer fields layout without having to delete the entire record, while preserving my business fields layout. Or am I drifting into deeper waters.

No, all customers would come from the business database.

Thank you for the suggestions. I will delve into it and see what I come up with.

Are you saying that if I created a business ID field in the customer table representing a foreign key relating to the primary key business ID field in the business table, and even though the relationship graph indicates I have a one to many relationship, I still have a one to one relationship based on the manner in which I create the layouts?

Thanks for the response. The database will eventually be web based. The business records will only be used for occasional direct mail marketing. The real activity of the database, (finds indexing etc), would take place in the customer table. I thought general performance would be greatly enhanced when searching through a thousand customer records versus searching through hundreds of thousands of business records to find a thousand customer records.

I realize that a one to one relationship is almost non existent, but I believe one is applicable in my situation, but I'm not sure how to set it up properly. I have defined 2 tables. Businesses: (The complete list of business names to solicit potential customers) Customers: (A customers list derived from the business name list who become customers .) One business = one customer. The only way I can get the relationship graph to recognize the relationship as a one to one relationship is to create a business ID primary key serial number for the business table, and a business ID primary key serial number for the customers table. Both serial numbers are defined the same. Is this properly setup for a one to one relationship, and if so how would be the best approach to maintain database integrity when creating a customer record. Would I create the new customer record from within the business record? If I create a new customer record from the customer table it does so in the order of the serial number rather than relating to the Business record ID that I need.