Jump to content

TonyInSeattle

Members
  • Posts

    16
  • Joined

  • Last visited

About TonyInSeattle

  • Birthday 01/13/1968

TonyInSeattle's Achievements

Apprentice

Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. Thank you, Søren! I actually thought this would be easier! At any rate, I spent some time scrutinizing this this morning to see if I can make it work for my case. I think I can, but I am worried about refreshing issues, as you mentioned. I'll go down this path, but if there are any other ideas out there, let me know! Tony
  2. I have three tables: STORES --< PRODUCTS >-- CATEGORIES Each store can hold many products (one-to-many relationship). And each product belongs to one of several categories. Several products can share the same category. So, for example, the "Main Street" store might have the products "Frog Fountain", "Copper Birdbath", and "Lion Fountain" in stock. The "Frog Fountain" and the "Lion Fountain" are each assigned "Fountain" category. The "Copper Birdbath" is assigned the "Birdbath" category. When I'm on a STORE layout, I'd like to see a list of products in stock. That's easy: I just create a portal between STORES and PRODUCTS. However, I would like to create a second portal on the STORE page that shows a count of the number of each products in that store for each category. So, for example, on the page for my Main Street Store, I'd have one portal that showed the items in stock: Frog Fountain Copper Birdbath Lion Fountain That's easy, but I'd like a second portal that shows the number of products in each category I have in stock. So, for this store, it would show (for example) Arbors - 0 Birdbaths - 1 Fountains - 2 Gazebos - 0 Seems easy enough, but I'm wracking my brain! The STORES and PRODUCTS tables are linked by a STORE ID, and the PRODUCTS and CATEGORIES tables are linked with a CATEGORY ID. However, I don't know how to isolate and count ONLY the number of products in each category that are in that store from a store page. I realize I can do something similar to this in a subsummary report, but I want to be able to interact with the data (click it to run scripts, edit fields, etc) and I understand you can't do that in reports. Anyone able to guide me in the right direction? Thank you!
  3. I'm using Filemaker Server Advanced 8. I have a database that has a lot of photos. When I use IWP to publish layouts that contain photos, I notice that the photos become huge (in KB, not in screen size!) and can take forever to download and display. If I choose "Save Picture As" from the web page and save the image to my Desktop, I'm forced to save as a BMP and the file size is 4 to 5 times larger than the actual JPG I added to the container in the database. I see from reading other posts that for newer versions of Filemaker there's software called SuperContainer that supposedly takes care of this problem. But is there anything I can do in Filemaker 8? I haven't been able to find a solution to this. Thanks, Tony
  4. I just bought a new iPhone, and I'd like to make special layouts and use IWP to access the database on it. By default, web pages on Safari on the iPhone open at 980 pixels wide. By the iPhone's screen is 380 (or so) pixels wide. It's possible to create a web page that automatically opens in an iPhone to the correct width, but I'm not sure how to do that in FMM. Here's a page from apple describing how to write a web page for the iPhone: http://developer.apple.com/iphone/designingcontent.html Is it possible for me to use IWP but somehow instruct my layouts to open at the right width on an iPhone? I'm not a coder, so I think CWP is over my head.
  5. Thank you! One question: Will these overlapping fields work with Instant Web Publishing? (I don't have it set up yet to test it.)
  6. SHORT DESCRIPTION OF PROBLEM: How do I keep the "second value" in a value list from disappearing if the relationship between the two tables is no longer valid? LONGER DESCRIPTION: I have two tables: PRODUCTS and SEASONS. Every product is assigned a season via a value list, and the season ID is the match field that links the two tables. The value list is defined to show only the "second value", which is the friendlier season name. Users can "close" seasons on seasons pages, meaning that the seasons have passed and will never be chosen for new products. I want a closed season to not be available in dropdown lists to keep the list from growing ever longer as years pass. To accomplish this I have a second match field between the two tables. If a season closes, the fields no longer match for that season, allowing the value list to show only open seasons. Here's the problem: If I return to a product page from a "closed" season, the season ID of the closed season is still stored with that product. But the Season Name has disappeared from the field. How did I get it to stay? All I see is the Season ID. POSSIBLE SOLUTIONS: I could create a second occurrence of the SEASONS table (SEASONS 2), where only Season ID is the match field. I could put a Season name field from the SEASONS 2 table over the Season ID field from the SEASONS table. But this seems clumsy. And will it even work with Instant Web Publishing? I was hoping I could just change the table in the value list to store the season ID from the SEASONS table, but show only the season name from the SEASONS 2 table, but that did not work. Any other ideas? See the attached for a mockup. THANK YOU!! Seasons_problem.zip
  7. Thank you for your continued help, but I think your solution is way over my head! (I think I need to change my skill level to beginner!) -) Is there some way you can show me more clearly what you mean? If it's easy enough (and you have the time), could you modify my example file so that the "excluded" portal works?
  8. (I've already added a post similar to this in a different forum and think it would be more appropriate here.) Let's say I have two tables: PRODUCTS and PRESENTATIONS, each with a unique ID key. Every product can be part of more than one presentation, and every presentation can include more than one product. So I create a join table titled PRODPRESJOIN. Each record in the join table contains 1 ProdID and 1 PresID, which are matched to their respective tables. (See the attached example.) So, if I'm on a layout based on the PRESENTATIONS page, it's easy to create a portal that shows me all the products that are included in the presentation. But how do I create a portal that shows me all of the products that are NOT included in this presentation? (I want to use such a portal to show the products that have not yet been added to the presentation so the user can click which ones he/she wants to add.) In the attached example, the portal labeled "excluded products" does not work. Any ideas? (I know this must be simple.) Example.zip
  9. I don't think a value list will work in my case because there will be too many products. I'm actually planning on filter the unincluded list of products even further in the portal (based on other product characteristics) so the user won't have to sort through too many products. So, is there a way to do this in the portal? Seems so simple, yet the solution eludes me! :/-)
  10. Let's say I have two tables: PRODUCTS and PRESENTATIONS, each with a unique ID key. Every product can be part of more than one presentation, and every presentation can include more than one product. So I create a join table titled PRODPRESJOIN. Each record in the join table contains 1 ProdID and 1 PresID, which are matched to their prospective tables. (See the attached example.) So, if I'm on a layout based on the PRESENTATIONS page, it's easy to create a portal that shows me all the products that are included in the presentation. But how do I create a portal that shows me all of the products that are NOT included in this presentation? In the attached example, the portal labeled "excluded products" does not work. Any ideas? (I know this must be simple.) Example.zip
  11. GetNthRecord works perfectly. Thank you! There's only 1 downside I see: this method copies my photo from the Pictures table to the Products table, which will greatly increase the size of my database since we have lots of photos. Is there a way to accomplish this so that I can view the photo(s) in the Pictures table from the Products record without actually copying it to my Products record?
  12. I have two tables: Products and Photos. Each Product has a unique ProdID, and each related picture has a ProdID for its corresponding product. ProdID is, obviously, the match key. Here's the question: On a product page, I would like to show the first picture from the related Photos table in a small window. Next to the picture, I would like to supply forward and backward buttons to thumb through each related picture in the Photos table. How can this be done? It seems portal-ish, but I'm not sure how I'd get the single-row portal to thumb through the related pictures. Furthermore, I'd like to supply a check box next to the pictures window that allows me to choose which picture is the "default" that should show up when I come back to this product page. Any ideas on how to go about this?
  13. I’m trying to create a dynamic search using a portal, with some values related to other tables, but I cannot get this to work. Here are the details: I have two tables: PRODUCTS and TASKS. Each product has a Product ID, Customer, and Department. On each product page, I have a portal to the TASKS table in which I can create tasks that automatically inherit the Product ID from the product. I also have a Tasks Search page, which is a tasks layout with a portal to a copy of the TASKS table. I want the user to be able to choose a Customer and Department from drop-down lists at the top of the page to see the related tasks in the portal below. For my key fields between the TASKS table copies, I have: • gCustomer and gDepartment, which are global fields that contain the Customer and Department values for which the user wants to search the tasks. • cCustomer and cDepartment, which are calculation fields that equal Customer & & “All”, and Department & & “All”. I would like to base the gCustomer and gDepartment value lists on the cCustomer and cDepartment values, so the user can choose a specific Customer or the value “All”, for example. When I change the Customer or Department of a Product, I want the Customer and Department of the associated tasks to update, too. I’m currently doing this by making them Calculation fields that link to the PRODUCTS table. But this causes problems: cCustomer and cDepartment must then be unstored, so I cannot use them as key fields or value lists. If I change Customer and Department in the task table to Auto-Enter calculations, they can be stored, but they don’t automatically update if the values change in the PRODUCTS table. I think I explain this all pretty well in the attached file. I’ve been working on this for weeks to no avail. I would appreciate any help you can give. Thanks! Tony TonyInSeattle_-_Dynamic_Search_with_Portals.zip
  14. Wow! Thank you! I really appreciate you taking the time to show me the solution. It works perfectly...
  15. That works! But any time you click in the field, you'll automatically erase the related field(s), even if you don't end up changing the value in the first field. Is there a way to erase the other two fields only if I end up changing the value in the first field?
×
×
  • Create New...

Important Information

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