Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About cruijff

  • Rank

Profile Information

  • Gender
    Not Telling
  1. Thank you Wim Decorte. I have abandoned the idea of using global fields for this issue and effectively implemented doughemi method. Thank you all.
  2. Thank you very much. That's the way I did it in my file, except it's working. Nothing I was just joking. The thing I didn't understand was about how global fields (in a shared db) work, reverting to their existing value when its content is changed from a client. How can one effectively change the content of a global field without accessing from the host? In a shared solution with FMS it would be quite annoying to "close" the db and open it just to change global fields. Edit: It seem you can't from the Notes first line http://www.filemaker.com/12help/html/add_view_data.4.48.html
  3. Ok doughemi, I tried your method and it's not working. When I create a record on my greentable which has fields who lookup to gConstants fields none of them gets filled in. There's surely something I'm doing wrong, I'll try to figure it out myself.
  4. Thank you for this advice, I guess this is the route I'll be taking. I have created three number fields in gConstants table: EUR_to_USD EUR_to_CHF CHF_to_USD and three Number fields on the greenTable EUR_to_USD_Current - Lookup to gConstants::EUR_to_USD EUR_to_CHF_Current - Lookup to gConstants::EUR_to_CHF CHF_to_USD_Current - Lookup to gConstants::CHF_to_USD And I linked them with Cartesian Product as you suggested in this way: Then I'll have a script on the greenTable using the values of EUR_to_USD_Current field. Is this what you meant? I don't understand w
  5. ....aaaaand now it works. what. I'll recap everything I did so that maybe you can help me avoiding mistakes. Table name: gConstants Fields: EUR_to_USD_Main (type: NUMBER) EUR_to_USD (type:CALCULATION) Calculation Result: EUR_to_USD = gConstants::EUR_to_USD_Main / Storage Options: Global /Indexing: unticked do not store, recalculate when needed / unticked Do not Evaluate when all reference fields are empty. I created the first (and only) record on gConstants table, I filled in the field gConstants::EUR_to_USD_Main with a numeric value. Closed and reopened db and BAM! the field
  6. Hi guys I have a problem with constant values. The constants I deal with are currency exchange rates, I have to set these constants once per year (maybe). Upon reading the topic http://fmforums.com/forum/topic/64043-best-way-to-store-access-constants/ I set up a table named gConstants and 1 calculation field named gConstants::EUR_to_USD, calculation result EUR_to_USD = 1,300 and I set it to global storage (options->storage->global). If I create a new record on this table (first record) the calculation field gets set to 1,3 and everything works fine: there's a script whic
  7. Thank you all guys. As comment pointed out the correct relationship is Manufacturing::man_prev = Manufacturing 2::manID I created a field named linked_qty and set it as related record showing the field Manufacturing2::warehouse_qty and all seems fine. (edit: is there another way to do so? I experienced problems in the past displaying a related record on other related tables). With "manual" insertion I did not mean that the FK is entered actually manually , I meant to say it is not an automated act, I have set it as pop-up from a value list, no worries!
  8. Thank you LaRetta, I'll give it a try! I don't know why I didn't think about this..
  9. Hi guys, I have a problem I'm struggling with: I have a table named Manufacturings (parent key field = Manufacturings::manID) which has a field named Manufacturings::man_prev, which displays the unique other manID (entered manually) with whom the Manufacturing is linked to for warehouse reasons. For example: Table: Manufacturings field1 = manID (manuf_012) - parent key field2 = man_prev (manuf_010) - entered manually field3 = warehouse_qty (1200) I would like to create on the table Manufacturings (e.g. manID = manuf_012) a field which shows the warehouse_qty of
  10. @bcooney I guess the answer to your question is yes: my "Orders line items" table has a field named date due, and line items are linked in a calendar to keep track of shipping dates. Am I doing something wrong?
  11. Thank you bcooney, the file you posted will be really useful I understand your point about not needing a "snapshot pdf" but I'll try to give you an explanation: When I receive an order from a customer I fill my order layout with the data on the customer's order (let's say my customer orders 1000 pcs of product A). I send to my customer the pdf produced by "order entry pdf layout", i.e. order confirmation. If I am not able to ship the whole 1000 pcs and want to do a partial shipping I'll have to modify the order line item, i.e. modify the order. (While I'm writing I understand I shoul
  12. Yes Ralph, but I don't understand HOW to write it on the server..
  13. Ok guys, I'm having a bit of trouble here. I read about remote containers (article "Remote Containers" by Wim Decorte & Steven H. Blackwell included) and I suspect this is the thing I need. I'll try to explain in detail what I'd like to achieve: I have a table named "Invoices", and for this table I have two layouts: "Invoices_layout" and "Invoices_pdf_layout". Of course "invoices_pdf_layout" is a pdf-like layout, whith a part "visible" in preview mode and a part cut off in preview mode. What I'd like to do , while sitting on "invoices_pdf_layout" is to execute a script (pressi
  14. Thank you Ralph. Even thou I don't want to make an automated server script (I don't need it) I'll certainly take a deep look at your posts, they'll certainly be useful to me.
  15. I don't need the files to be accessible from outside FM, all users have a copy of FMpro. I'll try to go for the container field solution, since I have 2 osx users and 1 windows user.
  • Create New...

Important Information

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