Brudders

DOH Thanks for the tip.

I have a self join table called banking which has two layouts, one layout is called "transactions" which lists transactions like a bank statement and contains and another layer "transaction detail" for modifying details. The portal displays correctly in transactions layout but I have added a button which has the value of go to related record. The problem is when clicking this button it just goes to the transaction details layout but it does not go to the record selected from the portal in transaction. I know this problem is related to the fact that this is a self join but im a little stumped on how to put it right. Any help you could offer would be very well received. Many thanks Ray banking.zip

I ran against the same problem and found a really good solution. Exeshield it costs $70 and what it will do is protect the runtime exe. You then have a choice if you want it to be a time trial or a maximum number of clicks trial. I downloaded the trial version and not joking I had my application protected within 25 minutes and how advanced your are with FM has nothing to do with it. I myself am a novice at FM. What this app does is takes your runtime exe and effectivly packs it into its own protective exe, once protected and executed the user has a choice of registering or continuing with app on trial. If the end user wants to register they have to send you a code that your now protected exe has generated. You then put this code into exeshield and it generates an unlock code and username. This is unique to that particular computer so non transferable. I had had a look at nightwings version evidently works with FM6 needs updating for FM7 I spent 20 minutes with it scratching my head then decided to look for something easier. Hope this helps www.exeshield.com

I have found solution called www.sdprotector.com which easily time trials FM runtime databases, if anyone is interested in converting their databases into runtimes, having it professionally packaged and time trialed drop me a line. Sorry MACS this is for Windows only

I have written a little application what I would like to do is release it with some inbuilt protection. I would like to make it unrestricted working for 30 days afterwhich it would require the user to enter a code that would remove the restictions. Any ideas on how to acheive this would be very welcome.

What a Star, Thanks. This is my first app using FM and have yet to learn all the tricks and capabilities so the feedback im getting in these forums is invaluble. Thanks for your help I really appreciate it.

With your help I have now sorted problem, thanks guys

Hi there thanks again, this is getting to be a habit :-) This is exactly what I am looking for with the exception of one thing and that is when you click on registration on invoice layout it should only list the registrations relating to the customer as defined in the customer layout. If you could shed some light on how to do that, that would be fantastic. Thanks again

I have two tables suppliers & purchasing each have their own layout, I have a portal on suppliers which lists all records relating in purchasing, works very nicely. But what I want to do is create a new layout with a portal on it that will list all records from purchasing not just records that are related to suppliers suppliers. Any assistance with this would be greatly appreciated. Many thanks

Many thanks for the quick responce, I have looked at your modifications I can see where your going with it but tbh its not quite where I need to go. I am writing a garage autoshop repair app. I am pretty much finished as it is very basic but hey thats what the requirment is and tbh im glad as it's my first FM app. Requirment There will only ever be one car on invoice. But it is possible that customer could have more than one car. So I need a portal/mechanism on invoice that has a popup list listing customers cars so that the right car can then be selected, (this list should only show the customers cars not all). Once correct car is selected it would populate the full car details on invoice. There is also another portal on invoice which is pulling over the customers address details. Customer details are entered via customer layout but so is cars details via a portal. Any further assistance you could offer would be gratefully received.

I am having a little problem with a DB that has three tables relationships are established and makes use of portals. The three tables are Customer, Cars, Invoices The theory is that 1st create customer which also updates cars table with required information. 2nd raise invoice that automatically populates customer name and car details. This works fine except if the customer has more than one car then the first record for cars is brough over into the invoice layout. . I need some kind of popuplist/mechanism that would enable the user to make a choice dependant on selection of cars. Any help offered is appreciated, I have attached example of what I am trying to acheive. Many Thanks Ray we1.zip

Thanks for all your help, with your examples I was able to tailor and get required result for my app. Your help is very much appreciated.

Reply to computer_geek Many thanks for the example it really helped with the date calculation, could you tell me the balance for invoice only calculated for that individual record how can I get balance fields for 30/60/90 days to calculate the whole table of invoices and give the total of all records. Thanks again

Very noobie question here. I have a table called purchase_invoices which is bound to a data entry layout (Purchase order entry), on this layout I would like to place a button which would list all records in a new laylout. I only wish to list certain fields and each record must be in a single row with the next record below etc. I do not wish to do this as a report as I would like to add some addition functionality like click on button to go to selected record in original layout. Any ideas would be welcome. Many thanks

I am writing a bookkeeping application and would like to display balances outstanding for invoices overdue by 30 60 90 day periods. What I would like to acheive is have 3 fields 30 60 90 which dynamically calculate balances based on age of invoice and result is balance of those invoices. Can anyone point me in the right direction