Ben Martin

Hi, iv just finished creating a database for company, to house customer details (such as name, address, number, credit card details etc), produce invoices and advice slips, and process credit card transactions. However one thing that has stumped me is the intergration of an address finder. Is there a ready made plugin that allows you to find addresses based on certain critrea such as postcode (zip code) or house number + street name etc? The customer will be using version 8.5 i expect, though i developed it on 8. So i could consider using the web viewer and possibley a website that provides this kind of functionality? Any advice appreciated. Regards, Ben.

Hi there, Thanks for your reply. I've literally just set up the calculation with Sum in it, and it appeared to fix the problem of only adding the current page. However i have had the issue of restocking the supplies, and im trying to decide a suitable, and simple solution at the moment. The idea of a restock table works, but over time, and this database could be used for many years, some items would end up with about 300 repititions. I quite liked the idea of having a button that can 'Add' 'x' amount to the current stock, but i cant seem to find a way to do this. For example; Current stock 101. Button = Add (x) amount. Clicking the button takes the typed amount and adds it to current stock. That can work find but it seems each time i change the amount, the Current stock level deducts the previous added amount before adding the new. For instance, current stock = 100. I add 10 which = 110. Next update i type 20 into the add 'x' box, but the calculation appears to minus the 10 before adding the 20. It doesnt accumulate. Any easy way around this? Thanks again, and i apologise if that didn't make a great deal of sense.

Hi there, Im relatively new to filemaker pro. Im creating a database to take and process orders, and i have most of the database in place part from one thing i cant seem to fix; The database has a stock list, with each item defined by product code, and a stock level (quantity). What i need to happen, is for the Quantity in stock to be calculated based on the quantity of that product that has been processed in the purchase orders. For example; Purchase order 1 - product 000001, quantity 10 Purchase order 2 - product 000001, quantity 15 Stock level = current stock level - purchase order 1 - purchase order 2, based on the product code (000001 in this example). I had a calculation setup where by; Stock level = base quantity - purchase orders:product quantity. This worked fine, for the one record visible on the page, it didn't take the other records available on the database into account. Is there anyway i can have the stock database updating from all records on my purchase orders database? Thanks in advance, Ben.