timber35150

Ender, At the present our business is managed around QBooks with regard to stock levels control. FM I think should be linked to QBooks pro somehow. Any ideas? Many Thanks.

John, The problem was due to additional developement of our database being carried out from a workstation/s whilst files were still being hosted. When i the novice developer was creating / developing additional scripts, i did not realise that the files for developement should have been copied over to a PC (stopping the FM service), then pasting back for FM Server to hosting once more. Simon.

its ok folk, have now rectified the problem.

Many thanks for the reply. We currently maintain stock level control via our accounts software, and have done so for many years. The problem we have is that the guys in the workshop have no user rights to access this programme (security reasons). What i am trying to introduce is a system so the chaps in admin know excatly who,what, and when to invoice a customer, after a clients machine has gone through our workshop. Filemaker is accessed in all departments of the business, and once the guys in the workshop carry out a job, he can print a record (job) from the SERVICE RECORDS file, and hand to accounts for them to sort out. My SERVICE RECORD file contains information about individual workshop jobs, client machine repairs, also our own machine repairs and warranty works. Parts Orders records are line items to be used via the portal in SERVICE RECORDS file, linked via the job number relationship. This is about as far as i have progressed, with no Parts tracking (number bought, number sold etc). At the moment stock level control is not reliable. As i said in my post, Filemaker is new to us her, and i would eventually like to have our accounts software / Filemaker integrated.

We have just introduced Server 5.5 into our small office, onto a file server running windows 2003 server.Workstations are on XP with FM6. This server business is all new to us here, and we are currently experiencing very slow connectivity on all workstations (e.g. opening files from buttons also scripts running very very slow). Its not a huge database, i would say its not even a complex one neither. On occasions it can take 4 to 5 sec onds for a script or file to open from a button. Can anyone point me in the right direction?

Hi, Brand new to FileMaker and can't see the wood for the trees! I would like my "qty on hand" field in my PARTS file to auto reduce by the qty a user enters, when sent to the PARTS ORDER file. Anyone help? E.G. The user finds the part he/she wishes to use, then clicks "add part to order" which does exactly that. This creates a new record in the PARTS ORDER file, where the user can enter how many parts he uses. In this file i have a "jobno." field which is related to the "SERVICE RECORD" file, jobno::jobno This file (SERVICE RECORD) displays a portal from the PARTS ORDER file, which has the unique jobno. identifier. I assume a calculation is required to reduce my qty on hand?

Hi, Brand new to FileMaker and can't see the wood for the trees! I would like my "qty on hand" field in my PARTS file to auto reduce by the qty a user enters, when used in the PARTS ORDER file. Anyone help? E.G. The user finds the part he/she wishes to use, then clicks "add part to order" which does exactly that. This creates a new record in the PARTS ORDER file, where the user can enter how many parts he uses. In this file i have a "jobno." field which is related to the "SERVICE RECORD" file, jobno::jobno This file (SERVICE RECORD) displays a portal from the PARTS ORDER file, which has the unique jobno. identifier. I assume a calculation is required?