chlowden Posted January 15, 2009 Share Posted January 15, 2009 Hello I have a strange problem. I have 2 dbs that have lookup fields. When the files are opened directly, the lookup fields work fine. When I serve them up & open the files remotely, the lookup fields no longer work, leaving blank fields. Is this normal? Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted January 16, 2009 Share Posted January 16, 2009 No, it's not normal. I suspect there is something amiss with your file references. Also, why are you using lookups? Steven Link to comment Share on other sites More sharing options...
chlowden Posted January 16, 2009 Author Share Posted January 16, 2009 Because I don't know how to write dbs that don't use them. Truth be told, I am rubbish at creating dbs but after alot of work and help, I get them working. In both cases, the lookup fields are used to copy info so that the subsequent entry has nolonger 'live' to change. One is an pay invoice & I don't want the entries changing every time I change an address or a figure. Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted January 16, 2009 Share Posted January 16, 2009 Understood. We all started at the beginning, more or less. Maybe take a look at auto-enter calculations. Also, take a look at these video tutorials. They can help you. Steven Link to comment Share on other sites More sharing options...
chlowden Posted January 16, 2009 Author Share Posted January 16, 2009 I presume that you mean timestamps as being auto calculations. The db is very simple. Each look up copies the result of a calculation to an invoice layout. Is this not good? Link to comment Share on other sites More sharing options...
chlowden Posted January 17, 2009 Author Share Posted January 17, 2009 I attach the file in question. They are for my wife, who administers a micro-theatre company. They are in french so I give a little explanation. LAFRONDE_MASTER is simple payslip tool. The layout 'Creer fiche de Paie Artiste' allows the creation of a payslip for an actor, with all the calculations in place. The button on the page creates a copy of the entries via lookups to a 2nd table called 'Archive fiche de Paie Artiste'. This all works fine on my machine but when I put it on FMSA9.03, the lookups show up blank. The same occurs for LAFRONDE_COMPTA. This is a basic (badly designed) accounting system. An expense is added to the 'creer' layout, button is pushed and the amount is copied via a lookup to the 'archive' layout where it is calculated so that the amount can either be calculated as part of sum per project, or as a global expense. Again this works on my machine, but not the server. Can anyone see if they get same result on their servers? Many thanks in advance. login:admin pass:admin Archive.zip Link to comment Share on other sites More sharing options...
chlowden Posted January 19, 2009 Author Share Posted January 19, 2009 Whoops, sorry. The login on the download is: admin, password: 191974 Please can somebody help. I can't see what I am doing wrong. Link to comment Share on other sites More sharing options...
chlowden Posted January 25, 2009 Author Share Posted January 25, 2009 After struggling with this issue, I found an alternative way to lookup that does work with FMSA. Use the following script to "copy & paste" info across tables & fields. Set Variable New Window Go to Layout New Record/Request Set Field The Set Variable has a name field that is a code that you create of the name of the field that you want to copy. The value is the field location on the table that you want to copy. The Set Field lets you choose where to paste the value and the in the 'Calculated result' window you copy the coded name you created in the Set Variable name field, KEEPING THE $ infront of the coded name. Hope this helps someone Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5563 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now