Skip navigation
(Virginia_Kirkendall)
Currently Being Moderated

Relational Data in SQL Server

Feb 15, 2005 2:51 PM

Hi:

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
293 Views   4 Replies   Latest reply: (Virginia_Kirkendall), Feb 16, 2005 6:38 AM
 
Replies
  • Currently Being Moderated
    1. (JRA3),
    Feb 15, 2005 3:46 PM   in reply to (Virginia_Kirkendall)
    Report
    Ginger,

    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.
     
    |
    Mark as:
  • Currently Being Moderated
    2. (Ulf_I_Andersson),
    Feb 16, 2005 12:27 AM   in reply to (Virginia_Kirkendall)
    Report
    I would do it with a webservice.
    /Ulf
     
    |
    Mark as:
  • Currently Being Moderated
    3. (Virginia_Kirkendall),
    Feb 16, 2005 6:33 AM   in reply to (Virginia_Kirkendall)
    Report
    Would you please expand upon this subject? I'm not at all familiar with using a webservice. In a nutshell, how would this work with inserting to >1 table?

    Thanks much,
    Ginger
     
    |
    Mark as:
  • Currently Being Moderated
    4. (Virginia_Kirkendall),
    Feb 16, 2005 6:38 AM   in reply to (Virginia_Kirkendall)
    Report
    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.

    Oh yes - I'm using the 7.0 version.
     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)