Gingerbread Man

Hi I have an accounts database in which I want to add the sum total of figures in the amount (text field) to appear in sub total (number field) which VAT is added to appear in VAT (number field) and finally end up with a grand total in the final (number field). It all works fine in the amount field if there is just one amount. As soon as I type in 2 or 3 amounts the sum is either just the first amount or an obscure figure. If I change amount field to a number field I can only type one number which is no good for invoicing. Any ideas?

YIPPEE – all working Thanks everso. I take your point about a book. Can you recommend one that I can delve in and out of rather than do a whole tutorial? Thanks again GBM

Hey, we all have to start somewhere!!! OK forget the rest, just help me with this. My dadabase has fields Name, Company, Address, which I want to use on Invoice. I have created a relationship from invoice to database where company=company In my invoice I have created a pop up menu using values from Company field in database. When I select company in pop-up menu I want the name and address fields to fill with the name and address data from that record on the database. The name and address fields in the invoice are from the related database i.e. :Name :Address and it still doesn't work. I know I'm nearly there. I would appreciate a last push. Thank you GBM

Hi Thanks for this I just don't know how to get the fields to fill with the information. What i'd like is to choose client from a pop up menu and the address fills automatically then type the job number and the job details fill automatically from job sheet. I'm quite a novice FM user but love what it can do, it just frustraites me that I can't get my head around how to do it. Could you gently explain how I might go about it if you have the time or email me an example if that's easier. Thanks. GBM

Hi I have a contact databse in filemaker 5.5 I am trying to set up an invoice database to create all my invoices from. To save typing every invoice I wish to be able to select client from a pop-up list and their address and contact details automatically fill in from the corresponding fields in my contact database. This should be very easy but I can't seem to work it out. I think my brain's on the wrong side. anyone help? If there's a better way I'm open to options. GBM

Hi Dana Thanks for the script. Unfortunately I don't think I'm quite there yet. Can you just give me one more shot at getting my head round it. Where do you state the number of labels required? There doesn't seem to be a field on either file to do this. When I try and run the script I get an error 'The previous script step "<unknown>" could not be completed. The only way I can create a number of lables is to import one and duplicate it the required number of times. The attached 2 files are what I wish to achieve. I assume I will have to create a different file for each of the 2 label sizes which is not a problem it's just creating the required number of labels for each item that I still can't figure even with the script. Thanks for bearing with me. Graham GBM

Hi Bob First of all many thanks, just a couple of things (isn't there always!!!). You'll have to bear with me. I'm not sure how to ceate a table file. Can you be more specific about the looping script. Can I use the item code number as the key field. I think that should do it but don't hold your breath!!! Thanks again Graham

Hi I have an FM database of 400 items containing codes + descriptions to print out onto labels. I have set up layouts of the 2 x Avery labels required. I have set a field containing a size code so I can search for all the items with large and all the items with small labels. Now I want to print them but some items I want 50 labels off, some I only want 6 off. Anyone any idea how I set this up so each item has a code, a description, a label size and a number of labels reqired. I hit print and out they come. It's all there apart from the printing problem. If I can't solve it I'm going to waste an awful lot of sheets of labels. Regards GBM

Hi I am trying to create a daily timesheet to help tract time and costs. I thought I could use the weekly time billing template that comes with the programme and adapt it but have hit calculation problems. I then tried to create from scatch but can't make the portal relationship work. I want the timesheet to work as file attached (Time Sheet Lorna.fp5). The related file (Time Sheet Lorna Items.fp5) that my emloyee sees just has the basic information that appears in the portal. I also need to link in the related file (Time Sheet Lorna Billing.fp5) which only I see which has fields that allow me to search by job number and work out time to bill on each job. I nearly got it working but because of the calculation scripts on the template being a 'Weekly Time Sheet' when I start a new day it brings up the previous day or days info too. I'm OK on single databases but when it comes to related records and portals it all goes a bit over my head. can anyone give me a simple potal or relationship that does what I need. Then I can probably do the rest. Thanks G