Jump to content


  • Posts

  • Joined

  • Last visited

NRT.Rob's Achievements


Contributor (5/14)

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

Recent Badges



  1. I'm a dufus. apparently someone else used this license key in my office. thanks Vaughn.
  2. Hi All, FMP 8 on a G4 mac running OS 10.3.9 (soon to be 10.4.11, but here we are). FMP Server 8.5 on... something else, but also mac OS. also old. I don't think it's a server issue. Running FMP8 on client works fine. However, when using "connect to remote" to connect to the server, I get a license conflict. With myself! -number of users connected to server doesn't affect it. -number of users on network doesn't affect it. -restart does not fix -deleting preferences does not fix -Reinstall did not fix -License key is a real key, on the jacket of the disk. this license was previously installed on this machine, but it's been through a format and a rename and the name I am conflicting with is the new client name, not the old one. I need some ideas please! Thanks.
  3. Actually, I just played with a global for a join field. it works like this: data entry/search field is just text, "customer tools", in a customer file. It has a relational value list/checkbox set reading ONLY Parts, in another database, that are marked as "Tool". The customer file has a join field, now a global, called joinTool that links all customer files with the tools. The global STAYS POPULATED IN FIND MODE, and so the checkbox set stays in the customer tool field! I just added a setGlobal script to the customer database, to set that global whenever the database is opened. The relationship only has to be good when someone is looking at the field to either mark what tool is owned, or searching for people who own certain tools. as I noted before I have about a dozen other "incidental" relationships that are not critical but are just handy, occasional things to have that don't warrant big database expansions, and this fixes the issue perfectly. Thanks! I wouldn't have thought that globals stayed populated in find mode, nor that a relationship would calculate in find mode. This is very useful.
  4. hmmm. I'll check that out. if it's as simple as adding a set field step to an enter find mode script, that would do the trick quite nicely. you can't tab into check boxes anyway (effectively), and I can just replace the enter find mode menu option with an enter find mode script for that database to do it every time find is used. No reason not to... work or not, it's worth a shot, thanks fenton!
  5. I'm not expecting anything Soren, I was just desparately hoping that the simple method I saw was workable in some way, even if it wasn't perfect. Since it's not simple, it's not workable. That's really unfortunate.. but it is what is. I guess I'll have to bite the bullet and add all those join tables and work up a system for populating and maintaining them. Or, I'll set up permissions so my users can't modify custom value lists >: That would probably be easiest, actually... thanks again for your responses!
  6. Hi Soren, Yes, I know a few ways I can handle this with join tables; I'm trying to avoid that if there is just some trick to make a relational value list stick around find mode, which would be so very, very much simpler here, and the problem doesn't warrant a major expansion to my database system. I have my fair share of "ready record" solutions in this database structure already, for "mission critical" problems similar to this where I need to be rigorous. Here, I just want to help my users track and find some incidental information to help them work quicker... without draining the next month of my available programming time : I appreciate your helpfulness; should I take it then that there is no way to make a relational value list stay populated in find mode?
  7. well, a portal would be useful for showing, say, "all tools" or "all fittings". But if I want to show only the tools that the client owns, to use a portal I'd have to use a join table for the many to many relationship. I think that's what you're saying? Problem is, my example is very simplified: in my actual databases, That would mean adding literally about a dozen new tables here for all the relationships to be used, then figuring out how to properly populate them and edit them. big, big PITA just to make a few fields use checkboxes in find mode! I can make the value lists populate with the related information I want to show, I just can't make it stick around in find mode. And this is stuff we need to be able to search by. It's not strictly "mission critical" information, so I'm not worried about strictly correct DB structures for it, but it is a very handy way to quickly find things we need so we can work faster. Thus, my desire for a more quick and dirty way of keeping these both in checkboxes, and populated in find mode. Thanks for responding Soren!
  8. I just wanted to say thanks for all the idea here. I'm fairly proud of myself, I now have a "syncmaster" file with a nice big button, that will automatically clone all of my developement databases, import data from the working copies, and set all serial field values. It's pretty gratifying to watch it all fly when I hit that button!! Now I'm just working on expunging any custom value lists that have any chance of changing. Thanks again everyone!!
  9. Hey all, sorry if this is a dupe question.. I did try to search for it first, figuring I can't be the first to run into it. assume I have only two databases: Parts, and Contacts. Parts have a field called "part types", where I can indicate if a particular part is a tool, pipe, or a fitting. (in the real world, there are many other options). In contacts, I want to show what tools a contact owns, what pipe, and what fittings. I would LIKE to use relational value lists for this, where in contacts, there is a checkbox set for each category (trust me, it is workable from a data entry standpoint). I set this up, and found that the relational value list shows "no values defined" in find mode. Pondering this, it also explains some of my dissapearing pop up menus elsewhere in my databases during find mode, though that was never a real problem so I never thought about it much... now it's a problem, because these fields need to be easily searchable, using the check boxes if possible. Again, it's a data entry issue.. without check boxes, the find gets real complicated for the user, real fast. Is there ANY WAY to make this work in find mode? I've played with indexing and such and it doesn't seem to work. I have found that using all values from a field works, just not "only related values", presumably because the join field doesn't show a value in find mode. But, Having to create separate tables for all of this means literally about a dozen new tables, and I have to find a way to script the populations and maintain them... big, big PITA. I'm doing all this to move away from custom value lists that add members regularly. again, that's a necessity of my current developement process. Currently these lists are all custom values, and users occasionally add values by hand, which would fail as I am currently developing remotely and syncing the databases on occasion with imports. I'm trying to get to a data-managed value list that will keep itself up to date with imports. thanks!
  10. Well, some downloads later and I think I have some helpful stuff, thanks Fenton! I do have FMP8 advanced, now, to work on this stuff. thanks so much for the serial field tip (another bit I would have fogotten) and the value list issue, which is in fact an issue NOW... luckily, It should not be a problem adding the field based method to the database which is actually an improvement I've wanted to make for awhile anyway in a few areas... good stuff. I can't really easily separate the data and interface here. I'm continually editing both aspects as the databases continue to grow, and i have very limited developement time I would rather dedicate to adding functionality than to going back and basically starting from scratch... This has been a several year project for me so far. It would probably set me back a few months to try and do a separation at this point. Thanks so much!
  11. again, I need internet for that though : Also, the big problem I have is having the presence of mind to stop in mid-programming-session and write down what I'm doing.. I'm usually thinking so hard about what I'm doing, I forget to do anything else. I can easily keep a text file on my notebook desktop.. my developement machine is mobile.. but It's actually stopping and writing things down that's hard for me to do midstream. So to document, I really need an end of session button that will help me see the difference between the current state of my DBs and the original state, so I can then write down all my doc stuff. Or, that's at least the "ideal" solution I'm dreaming of. I suppose it would be more ideal for it to flawlessly write the documentation for me :, but the end of session comparison button would do as well...
  12. David, thanks for the response. If I had home internet and a helper in the office I could trust I would probably use the method you describe, which is basically what I do now when I code while I'm at the office. I am programming both interface and data regularly as I expand our database suite's capabilities. and the file merge seems to have only marginal benefits.. the cloning, specifically, and some less duplication in scripts. That's about it, right? Ender, VERY good point about the mapping. I don't delete fields very often but that is something I would not have thought of, thank you. I would like to keep the log, but I struggle with it for sure. Anything that interrupts my mojo when I'm coding causes problems, because it sure does suck me in... I just plain forget to write down what I'm doing when I'm "jamming" on it. Any tips, or plugins to ease documentation out there? Ideally I'd love to do a programming session, then hit a button and have something tell me everything that changed. I can document like mad, but it's way easier for me to do it all at once with the list of changed items...
  13. Hi All, So I recently got an older powerbook so I can do my filemaker 8 developement at home, late at night. I have a comprehensive relational database suite consisting of about 35 files in two folders (a main and a "support databases" folder). My issue is, I go home, I do some changes on a copy of the databases. then I come in at some point and I want to deploy my updated solution, which I may have been working on for a month or a day, depending on the additions I have made. In the meantime, 5 users in the office have been working on the real databases. So, I need to sync the two. Ideally, I would clone all of my new DBs, import all the data from the existing DBs into the new clones, and do any manual clean up that OF COURSE I clearly noted for myself to go over in the final copy of the new, ready to be deployed databases. The problem is.. this is about 35 files. Doing 35 clones and 35 imports is pretty ridiculous, at least manually. Is it possible to applescript the cloning and import process? If so.. I imagine I am not the first person to do this.. are there any examples of this already out there? Or, does anyone have a better idea about how to do this continual "redeployment"? Thanks in advance.
  14. all this time and I never noticed that. *smacks forehead*. Thank you both so much!
  15. Interesting.. how do I access that return character you show? And thank you, by the way.
  • Create New...

Important Information

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