owaring

Thanks again. Having a field in the dates table for each item will prove difficult as a modest system offers 300 items for hire, as well as the facility for items to be added or removed by the users. The current system is scripted on a per item record basis using script triggers but there are a number of scenarios where adjusting the quantity or type of item on one line has multiple effects on line items in other orders. e.g. increase/decrease of qty, item change, date change, job cancelation The efficiency of my current version, along with the prevention of erroneous calculations has lead me to want this 'dynamic' solution. As always comments, suggestions and solutions welcomed!

not sure if I follow... I do have a table of available stock levels for each item yes

demo.fp7.zipdemo file

setting gProductID in the dates table only gives us data for the ONE itemID we're dealing with. Ultimately I want a calculation field in the order items record without having to change anything

Thanks comment Apart from the dates architecture this is what I have. The calculation in the dates table gets the sum per day from the second table, allowing a cal in the first table to get the max of all days This still requires setting the global auxiliary field in for each individual record, I hope to make it dynamic I'm working on a file to demonstrate...

I have been building/maintaining a stock control system for a number of years now. Part of the system allows hire stock to be booked to an order and calculating from inventory stock levels and other orders in the same time period, and reserve x amount of available items. I have a working version of this that I would like to improve with the forums help. The current version works as follows; Table "Orders" A table with orders in, and a daughter table of order items. Table "Order Items" Each order line has a qty field a start timestamp and an end timestamp Table "Dates" This table contains a record for every day in the last five years and next five years. it also contains an 'auxiliary' field use in a relationship that I shall explain. The dates are maintained and checked on start up. Relationships as follows; order items connects to dates where order item::start date ≤ dates:date AND order item::end date ≥ dates:date a second instance of the order items table exists on the 'other side' of the dates table with the relationships; order item2::start date ≤ dates:date AND order item2::end date ≥ dates:date AND dates::auxiliary = order item2::key the auxiliary field in dates table is set to the key value of the order item record this allows the dates table to see from the second order item table records matching the date and key of our auxiliary a quick calculation field in the dates table returns the maximum number of qty in records in the second order items table for each day returning to the original order items table we can now see dates records matching the order and the maximum on each of those days another easy calc tells us the maximum for the period The problem I have with this as it stands is that each time you work with a different record in the order items table you have to update the auxiliary field in the dates table, and then return to the original order items table and perform a relookup. This is fine with a couple of script triggers, but becomes slow when updating multiple item records, for instance when extending an order by a day or two! I am looking to achieve this in an improved solution so that each order item line can dynamically perform these calculations. I hope my english has conveyed that in a half decent manner . I do not currently have a file with these core tables stripped back in isolation but could work on one if needed. Ideas welcomed,many thanks for taking the time to read. owaring

I have a system that logs radio frequencies. For each frequency I need to compare with all other frequencies and all results of calculations. The calcultaions are achieved using 2 frequencies; Therefore f1(frequency 1) needs to be compared with f2, f3, ... fn and have all 4 calculations performed f1 vs f2, f3 ... fn and the results of which compared against f1,f2,f3 ... fn I am trying to achieve this through relatoinships alone, but see how to without a relationship for every frequency Any ideas? Many thanks

each aircraft has a different price for each different lesson eg Aircraft 1 - Lesson Type 1 - £1 Aircraft 1 - Lesson Type 2 - £2 Aircraft 1 - Lesson Type 3 - £3 Aircraft 2 - Lesson Type 1 - £2 Aircraft 2 - Lesson Type 2 - £5 Aircraft 2 - Lesson Type 3 - £2 Aircraft 3 - Lesson Type 1 - £5 Aircraft 3 - Lesson Type 2 - £21 Aircraft 3 - Lesson Type 3 - £4 Each time a new lesson type is added a field needs to become available for each aircraft..........

I may be having a bit of a senior moment here but wanted to put a question out to the room....... I need to create a price list. SImple enough eh?! This list should have 2 'sets' of management. Firstly should be a list of aircraft, priced per hour second is a list of types of lessons in those aircraft each aircraft has a different price for a different lesson etc the management should be able to add aircraft and lesson types as they see fit. how would you approach this?

thanks, so would you import user name and then set to change password at first log in? my one client has this file running on FMS and we use EA with ease. Am I correct in thinking there is no work around for EA without FMS?>

I have a solution which several customers have their own, identical, versions of. As I continued developing the system, I need to find a way to keep my clients accounts on the live files, in line with any new files I distribute. Are there any recognised or recommended methods for copying or importing user accounts from one file to another? Advance thanks.

Thanks Vaughn, I have server so this will all be cool, not sure where I dreamt up using another fmp file, ah well! Thanks again

External Authentication exactly...... can this be done via another fmp file? if so how?

Did I imagine it or can I manage security of a file via a separate file which contains just users? Both files to be hosted on the server. FMP11

this way each time I release an updated file I don't have to go in and make all of the tweaks that personalise the one clients system there is no data in the layouts file, it's purely formatting.

I am developing a system which will be available for different clients to use. My only differences from one client to another is a hand full layouts each customised for outputting quotes etc...... to simplify further development I have decided that I will use a separate file on the users machine to contain these layouts. my question then is how best to do this. I figure in my layout file i need to add the main file as a data source in order to display data. the layout file will be in a known location (I'll do it) but i cant be so sure of the main file. ideas?

As a result of showing a few people the equipment hire system I have been working on I have been approached to do 2 or 3 other filemaker projects. I have received a brief for one, and will have for the second by the end of the week, the clients obviously now wanting pricing for my services. This is where I am unsure how to proceed. I was wondering if you could advise me on how to set out a pricing structure as well as ball park figures for "the going rate" Do you have any example quotes you could share with me?

I guess the main question really is MacMini or MacMini Server?

Yes sorry FM Server Pro! Thanks for that. What problems do you think I could encounter if users went >10?

Any recommendations on running Filemaker Server Pro on a Mac Mini running Snow Leopard?

perfect - with an extra ) snuck in!! : many thanks

Let ([ n = Count(equipment_list_ST_aux::pk_equipment_list_line_id) ; all = equipment_list_ST_aux::pk_equipment_list_line_id ; prev = GetNthRecord ( all ; If (n>0;n;0) )]; prev )

I have a calculation "prev_st_1" field that is used in a relationship so that "st" can be calculated. because of the relationship structure that "prev_st_1" uses to calculate the first x records have no relations and thus return a ? I need this field to return a 0 if one of the referenced fields is empty, so that the other relationship can work. My current work around is to create a second calc field "prev_st_2" which looks at "prev_st_1" and if it is empty returns a 0, else returns the value. any ideas or is my work around as good as it gets?

Now that I've found some time to return to this...... Watched the video, thanks. All common sense to me. Re ran my script and actually bothered to open the outputted pdf file.......... Turns out an error in my script was sending every record to the output file not just 1!! Once I'd fixed that adding the image was inconsequential, as it should've been all along!! Thanks for your help Søren! Hope you don't feel my stupidity wasted your time.

Yes inserting as a picture via the menu. Thanks for the link, cant quite justify the $35 dollars right now. What I cant understand is that the excel sheet I'm replicating in this layout produces a pdf of only 336K. Even if I size the original uncompressed graphic to a whole page in preview and print a pdf from there the file size is no more than 350K It seems FMP is generating a whole load of unnecessary data somewhere