Hey Guys, I am a completely new user to Filemaker so please be patient with me. Everything I have done on the attached file is through self-learning.

I have tried to merge Inventory management with invoicing and basic accounts for my small business.

I have succeeded so far however stuck at a small point

Basically for one design no. i may have multiple suppliers and multiple cartons no.s

When I create the invoice successfuly selecting the design no. lot no. (Supplier name) & carton and input my desired pcs/yards, instead of deducting stock from the selected carton no. Filemaker decides to subtract it from the first carton no. only.

I have attached the database with the basic testing information.

Please help, I have worked far too much on this to let it go.

Thanks

Main Choice.fp7.zip

oops I completely forgot...the username is Main Choice and there is no password just leave it blank. thanks again guys

That is not a Full Access user name/password.

Sorry about that .. just completely swamped right now .. here you go

username: admin

password: 2711

thanks for you help

Still unable to get in to full access (if you replaced the first file with one using Admin and 2711). If you planned to attach a different file, it didn't attach.

And welcome to FM Forums!

You can get in with that user name/password. But you must Advanced, and use the script debugger to halt the startup script, and put the standard menus back in place.

hey guys thanks for trying to take a look in the file and replying so quickly. Sorry about the lock on the file completely forgot about that. I have removed the login and removed the custom menus. Thanks for your help

Regards

Main Choice-1.fp7.zip