ThatDeadDude

Thanks. I kind of thought as much. Just that I'm a lazy bugger. Seriously though, yeah, thinking about it, it probably will be best to go that way. It's just among other things having to know which fields were in the original table, in order to copy them manually, is annoying when there's 50 of them, never mind many times that.

Hi there. I'm trying to convert the company's current FM5 solution, to now, FM8. So far it's going pretty smoothly, except for the fact that I'm having to break some flatfile parts down into a proper relational system. Again, that's not so much of a problem, except for the number of fields I have to go through. Basically I'm making copies of the flat file, relating them, and then deleting the unused fields in each. So yeah, I'm just looking to know... is there an easier way to do this?

Doesn't really work. The way the help file got me setting it up, it just takes me to the intermediary file, as apposed to the one I want, which is the actual candidate record. Okay, wait, you're right. If I call a similar event in the intermediary file, it all works out. Thanks.

I am trying to create a solution for a recruitment company. I've set up separate databases for recruiter details, and candidate details. Each candidate, and each recruiter is assigned a serial number as a reference ID. No problems there. Now, what I've been asked to do is have it so that you can go to the record for a specific recruiter, and see all the candidates who are related in whatever way to that, and vice versa. After trawling through the FM5 help files, I eventually got a many-to-many relationship up and running using the reference IDs as the base relationships. What I'm trying to do now, however, is get it so that, say, you click on a specific candidate's details in the portal in the recruiter's database, and it will then take you to the client database, setting the current record to be the one you just clicked. I've worked out how to do this using copy[] and paste[], but I'd rather have a method that wouldn't overwrite anything on the clipboard. Any ideas?

Thanks. I'll just have to see if I can improve my understanding of PHP a bit, and find a way to automate it all if we decide to go for the method.

Anyone?

Thanks for the advice. I've been looking at the options and speaking with my colleagues. I've tried cafePHP, and find that it works sufficiently. Thing is, that solution doesn't supply connectvity to enough users. We will be having at least four users connecting to FM just in the office, which could potentially cause problems in case of any web access, at least in my understanding of how the system works. I do assume thought that we could use the "non Advanced" version of Server 7 with cafePHP, and then have up to 250 users connecting? In this case, however, for budgetary reasons, we would not necessarily be able to use a large number of Filemaker Pro clients. Would it actually in any way be a good idea to use IWP in place of the usual clients? I realise I've rambled a bit here, so I'll recap the question. Should we go for Filemaker Pro 7 with cafePHP, or Filemaker Server 7, and in that case would it be worth just using IWP for client access? On the other suggestion, how would I go about synchronising with a MySQL server? Sorry, but I'm fairly new to the subject.

I work for a small company. We are currently using FMP 5 for all our records - ie client and customer databases, archives, product listings etc. Thing is, we're looking at upgrading to version 7, and at the same time building a new website capable of serving some of the information in the databases to internet users. I was looking at the custom web publishing features of the Web Companion in FMP 5, as I'm not foreseeing vvery much traffic, but I see that this functionality has been removed from all versions of FMP 7 except server advanced. So I need some advice. We're looking at running the database off a dedicated server. Now, what would be the best way to get to our aims? We can't really afford Server Advanced, but I don't really like the constraints of instant web publishing. Should we try set up our own web server? Or find hosting? Or something else entirely?