I need to set up an interactive online form connected to my SQL Server database. The form is an application where there is one person who is related to x number of different labor categories, for example. I have the tables set up in SQL Server. 1 Applicant to many labor categories.
My question is how to set up the data connection. Setting up to one table is a no brainer, but I can't wrap my brain around how the relationships are established. *How will the key from tblApplicant get inserted into tblLabor when the user makes an entry into that subform on the pdf?*
Another question: is there another source of help besides the help that comes with Forms Designer? I find it lacking for data connectivty beyond the basics of setting up a connection. Also - addl help and examples for scripting would be nice too.
Many thanks -- Ginger
(Virginia_Kirkendall), Feb 16, 2005 6:38 AM
Frankly it's not as easy as it should be... unless there are some improvements in Designer 7.0.
You will have to script your data and script your field matching. If your still using 5.0... don't use VBScript, as it will be no longer supported. So you will need to develop your script in Jscript to read your database and you can call multiple tables in your select and from statement, something that you can not do with the databinding control panel.
To do this, drop a script control on your form and edit away.
So is it the same idea as using ADO with ASP ? Make a connection; Set up the recordset; match the fields. Not too much more advanced than creating a web page from scratch? Hmmmm.... I should have done more research into this product before purchase.
Does anyone know of examples of this type of script? Inserting related data into > than one table? There have to be other people who are doing this with Acrobat.