Boto

thanks i'll check it out.

Thanks for your comments on this subject... in the time it takes for the fm 7 book to arrive i have plenty of time deciding if i need one or not. Maybe the bible isnt a very good book on fm but it is on many other topics so i figured this one must be good... thanks for the replys

can you maybe provide an example? Still, this is also very helpfull... i'll go search their site! greetz

Not the solution in here just a question that can bring some light in this situation... Okay so you want to assign unique random numbers to a number of records... but is it like you have 200 records and want to appoint the numbers 000 to 200 in random order, or is it more like 50 records and appoint a random value from 0000 to 9999.. Cause in situation 1, you might want to look to a reversed approach, adding 001 to a random record and then adding 002 and so on.... cause the chance the random generator generates a valid integer in situation 1 near the end of the cycle is about 0,5%... imagine what the searchtime would be with 10.000+ integers and the same amount of records.

In the mean time i found a book... but it

Maybe this does the trick... I suppose your web help system has an URL, so you can make a help button with an action: Open URL and point to your Webhelp utility... and then i suppose all the programs you mentioned can do the trick. greetz

I read the example, but it uses two variables and i want to send 2 database attributes. So the values of offer::offerID and offer::carID have to be sent to an other lay-out... i can't get it working.

Thanks for the reply... i changed the situation a bit and worked it out a little further. I ran into a more specific problem and posted it in an other section. Thanks again http://www.fmforums.com/threads/showflat.php/Cat/0/Number/106884/page/0/view/collapsed/sb/5/o/all/fpart/1

Edit: FM7pro on Max OS X Panther Okay this is the situation 1/ table with an offer, this one has an OfferID, a Car ID, MotorOption, a Date etc., the CarID points to the car in question 2/ table with the car/motortype price list, CarID, MotorOption and Price 3/ table with rows on the offer, so this one has OfferID, RowID, OptionID, totalprice, quantity 4/ table with Options, has OptionID, OptionSpecs ans Price I want to make a new offer, by pressing a button new offer, then i select wich car it's about and select the motortype which sets the baseprice by choosing from a portal (that connects from table 1 to 2). The button sends the CarID to table 4 in list mode who then shows all available options on that specific car, then you can add a option with a button (which sets the quantity and OptionID of table 3 on 1) Its also possible to use a pulldown menu which sets the quantity seperatally. The problem lies in the fact that i cant seem to get the OfferID from table 1 to table 3. All other data gives no problem... only the Offer ID Table 1: pk: OfferteID foreignkey: BootID Table 2: pk: BootID Table 3: pk: RowID foreignkeys: OfferID, OptionID Table 4: pk: OptionID thanks!

I need to pass 2 variables to a script, is this possible somehow... cause i seem to miss the function of defining custom variables in the scripting of FM7 (used to work with Access which allows this in the VB scripting/programming). Thx in advance

I'll try to explain what i want. I've got a customer (ID,name, adress, etc.) The customer wants to buy a boat, and i want to send him an offer wich i would like to store in the database also (for future reference)(type of boat, customerID, price, options, etc.). One customer could also have more than 1 offers (some past validity, some still valid) (i suppose at this moment i need 2 tables, so one for the customer, one for the offers) The story continues, cause i want to make the offer also using FM7, so i search for the customer and push a button add offer... FM then takes me to a screen at wich i must first select the type of boat the offer is about (cause we've (unfortunatally) got more then 1 types of boats), when the boat is selected, all the possible opions for that type of boat become visible. In front of the options are checkboxes to select the option. Also the prices automatically popup when an option is selected and you can also see the total price. At this stage my database becomes more complex, because now i believe i need 1 table wich defines my boats, one table defining all available options, one table defining wich options belong to wich boat at which cost (so that's a n:m with a join). Okay so now the joined table from the last paragraph contains all the available options, now i want it to be connected to the offer. So in the offer table i define the CustomerID and the offerID, the date, the total price by calculation etc, but the most important which type of boat! because this is also a n:m we need another join table (row). So we've got: customer <--> offer <--> row [color:"white"]xxxxxxxxxxxxxxxxxxxxxxxxxxxx ^ [color:"white"]xxxxxxxxxxxxxxxxxxxxxxxxxxxx | [color:"white"]xxxxxxxxxxxxalloptions <--> option <--> boat And now we reach the point that my mind won't cooperate ... Who can tell me where the mistake is in the above piece, or maybe tell me somethin to clear things up. I think the problem lies in the fact in which table i define which boat the customer wants, because that means that fact has to be transported through row to option where the appropriate options are then selected. Sorry for the big post, but thanks in advance! Also sorry for my terrible English greetz Boto

Hi, First let me start of by thanking the founders of this forum for a job well done.. Now for my question, can you guys/girls recommend some good books on FM7 pro, my main interest is making small applications for organization support systems like a HRM and a Customer Management System. I know the basics of databasing in FM like making relationships and creating layout. Perhaps something about scripting or using applescript in combination with FM. Thanks!