JamesHunt

great! it mostly works. I'm not sure I understand what is going on, could you explain it to me? I see the join table has some calculations. I don't get what the create and serial lookup tables are for? The only other thing is, I want to be able to create a new contact record by entering a name that does not exist in the drop down box on the event layout. Is this as simple as allowing creation of records thru the join table>contacts2 relationship?

Just diving in here, please excuse if this is an obvious mistake... I've created 3 tables; 1 event info, 1 occurance of event, 1 contacts. I have 2 portals on the event layout. One displays related occurances of the event, and one displays related contacts for the event, pulling records from the appropriate table. I have the portals set to "allow creation of record" on the corresponding table. What I want is to enter the data from these portals and have it stored in the related table. This works fine for the occurances of events, because there is only 1 event for every occurance of the event. But for contacts there can be 1 contact for many events, and also many contacts for 1 event. So I enter the contact in the portal and it creates a contact record. But then I go to the next event. I want to make the same contact also a contact in this event. So I enter the same contact, but it creates a duplicate record in the contact table. I want it to realize the contact is already in there and just add a second event to the contact record. Does that make sense? But the tables are linked thru an eventID, so it doesn't find a match for the new event id and creates a new record. I tried making a join table that holds an eventID and a contact ID, so each contact could be related to multiple eventIDs, but the same thing happened. Sorry for such a long post, but if you can help I would really appreciate it!

I remember reading a few weeks ago that while Server 7 uses SSL encryption between server and client (using "open remote"), the login/pass for the database is not submitted with SSL. The SSL is only applied to the data after login. This doesn't make any sense to me, but I remember reading some posts with some very upset users who discovered the bug. Can anyone confirm this, or if it has been fixed? Thanks!

I remember reading a few weeks ago that while Server 7 uses SSL encryption between server and client (using "open remote"), the login/pass for the database is not submitted with SSL. The SSL is only applied to the data after login. This doesn't make any sense to me, but I remember reading some posts with some very upset users who discovered the bug. Can anyone confirm this, or if it has been fixed? Thanks!

I remember reading a few weeks ago that while Server 7 uses SSL encryption between server and client (using "open remote"), the login/pass for the database is not submitted with SSL. The SSL is only applied to the data after login. This doesn't make any sense to me, but I remember reading some posts with some very upset users who discovered the bug. Can anyone confirm this, or if it has been fixed? Thanks!

Doesn't FileMaker Server use SSL for server/client communication? Why would you need to use SSH on top of that?

Doesn't FileMaker Server use SSL for server/client communication? Why would you need to use SSH on top of that?

Doesn't FileMaker Server use SSL for server/client communication? Why would you need to use SSH on top of that?

I don't have a Win 2k3 server box. The FMP Server 7 is running Mac OSX. The clients are running Win XP Pro (not server) and Win 2k SP4 (not server). Since the VPN will create a tunnel at the speed of each location's upload speed, the tunnel will be 600kbps. Do you think this is fast enough to be useable on a daily basis?

I've read the numerous threads here regarding VPN feasability and alternatives such as terminal services, but I would like to follow up with a discussion related to my specific situation. 2 offices remotely connected through a VPN hardware solution. Both are using ADSL, and speed is currently 1500/256, but soon to upgraded to 6000/600. FMP Server 7 hosted on OSX, clients running FMP7 on WinXP and 2K. There are about 8 clients on the LAN side of the server and 8 clients on the remote VPN side. How will the performance be for the VPN users on DSL of this speed using the standard FMP "Open Remote" connection? Not all 8 VPN clients will access at the same time, probably 2 or 3 at most. I understand terminal services would be much faster, but it requires another hardware investment since it will not run on the same server. Is this going to be usable, or should I just resign myself to requesting another server box? Thanks for any advice!