wlisac

the applescript didn't work :P

Hey, I have a drop-down list with auto-complete from value list enabled. Go to next object using TAB and RETURN are enabled. If I'm in the field and type the letter A to start my auto-complete I see the dropdown... I press the down arrow to move my selection from Apple to Apricot and then press tab. It works. But now if I shift-tab back into that field, I see a list of all my values again, but if I try and use the arrow keys to change the selection only pressing RETURN actually changes the field value - tab simply moves to the next field and doesn't update the field (like it would on a webpage for example)... this behavior will mess up my users. Any help on how to have the "tab" behavior act like the "return" behavior would be greatly appreciated. My first idea was to create a script trigger that listens for the tab key and then uses applescript to interfere and press the return key.. but this is not cross-platform, and I'm not even sure it will work. Thanks for the help! - Will

It isn't a price per customer, it's a actually a price "per team" that will be selling to the end customer. There likely won't be more than 10 teams so I'm not too worried about the stress on the join table. However what you said has made me think. I might have categories.... but with a twist haha :)

Ah, you're right. It does work! I was confused by the 3-prong connectors on both ends of the relationship: I guess I could still make sure the price is unique by having a PriceID field in the Prices table still = CompID&ProdID... I was told early on to make sure my serial numbers had unique leading text... for example company serial numbers are COMP0000001 and Products are PROD0000001 Is that dumb to have leading text? Also, is there a better way to make sure that there is only one price for each comp/prod combo? Thank you so much for being so generous with your help! You are awesome! - Will

Another relationship question (I think). What I’m trying to model with my graph: There will be different teams that will be selling the same products to different customers, and possibly at different prices. Customers can be put into groups, but it’s not mandatory. Here is a simplified ER Diagram: The red represents entities will be “owned” by one team and will never change teams. The green represents entities that will also be owned by one team, but could possibly change teams. I don’t want teams to be able to see any of the other teams’ records. I think I want everyone to share a product list. Prices (and costs) will depend on which team invoices the item. I’m mostly struggling with how to relate teams and team members to the rest of the graph. I was also thinking of putting a field called TeamsID in every record of every "owned" entity and using accounts and privileges to determine which records the current "logged in team" could see. It's weird because it's almost like having several separate databases in one database. Any comments or suggestions would be greatly appreciated! Thanks, Will

That sounds like what I did - I called this "child" table "PRICES". However, I'm not relating PRICES and LINES through the fields CompanyID and ProductID directly, instead through another field called PricesID that = CompanyID&ProductID Is there a reason to hook it up through the two fields? I didn't because it ended up being a many-to-many relationship. By forcing PricesID to be unique it creates a one-to-one relationship.

Ah ha! I just got it to work, but is this the best way: I created a field called _pk_prices_id in the PRICES table that = _fk_companies_id & _fk_products_id with unique validation. I then linked _pk_prices_id to Line Items with a field called _fk_prices_id where _fk_prices_id also = _fk_companies_id & _fk_products_id but this time not unique. Does this make sense to create a key that is determined by concatenating other keys? Thanks!

Maybe this will make it a little more clear. This is what I've come up with but I can't find a way to properly connect Prices to Line Items. The real kicker is that while many companies can have many prices, and many products can have many prices - one company can only have one price for each product. Lol I hope I'm making sense! Thanks for any help, Will

It is an invoice. I removed the Invoice table from the graph to simplify it. But what you are saying is exactly what I'm trying to do. Create an invoice, add line items, get the product info from the products table, and get different prices for each product depending on which company is placing the order. Thanks for your help! - Will

So I'm pretty new to FileMaker and I have a relationship graph question. A screenshot is attached to make this easier. My companies have many line items. My products have many line items. However, my products also need to have many prices, but these prices depend on which company is getting the line item. All fields in LINES need to be looked up from PRODUCTS and PRICES. How would I hook PRICES up to the relationship graph? I tried creating different TOs of Prices but I can't seem to figure out how to get LINES to properly look up PRICES dependent on the company. Thanks for any help!

FileMaker has been pretty disappointing with its UI creation abilities... oh well, thanks for answering! - Will (I'm from Portland too.. cool!)

Hey guys - I'm new to filemaker and I am wondering if there is a way to lock a picture to the background of my body. Basically I don't want the image to scroll when I scroll the rest of the page. Is this possible? A web example would be something like twitter.com where the background clouds don't move when you scroll. Thanks, Will