You can use FormCalc instead of Javascript and either do:$ = Table1.Row1.tptw1 + Table1.Row2.tptw2 + etcor you can name all the rows and the cells with the number the same thing (ie. call them all Row1 and then it will automatically make it Row1[0], Row1[1], etc and do the same with the cell) and th...

In Object> Pagination you need to make sure the 'After' is set to 'Continue Filling Parent'. That should remove the extra pages.

In Object> Pagination you need to make sure the 'After' is set to 'Continue Filling Parent'. That should remove the extra page.

So I have now worked out the SQL bit and have a OLEDB connection with an SQL query which links the tables. It gives me the correct record for one client but what I now don't know is the code to put into the form so you can enter a client number and it will bring up that record. I have a client numbe...

what about using + for yes and - for no in your dropdown list? would that work for you?

and how do I do that? That is the bit I need to know.

OK so I have watched the video but I have multiple data connections and I am not sure how to link them together to get the one record? (ie. the client number is in one table of the database and then in a seperate table ( so new data connection) is the address and in a seperate table are other detail...

I have a form with a OLEDB connection and I have bound certain fields to it (name, address etc.). What I want to do is allow the user to put in their client number and then the form fills in the other information (name, address etc) from the database. How do I do this (in formcalc if possible)? Than...

the basic script (in formcalc) is:$ = Date2Num(endDate.formattedValue, "DD/MM/YYYY") - Date2Num(startDate.formattedValue,"DD/MM/YYYY") // the DD/MM/YYYY part should be whatever format you have set your date fields to.You put this script in the calculate field of the textbox. You may want to put in s...

You can use (in formcalc) the Date2Num function to turn your dates into numbers which you can then subtract the end date from the start date to get the number of days in between. You could put that calculation into the restrictedDays field so it will calculate automatically without the need for a bu...