Browse by Tags

Submit 2007

Hi there, I have a form based on an Access 2007 database. The form is a Purchase Order form. When "submitting" the form I would like to save a record in the database PLUS send an email to a person who can either Approve or Reject the purchase order before it is sent to the Supplier. On the...

Posted to Newbie Questions (Forum) by Gary Burke on 10-13-2008
SQL Server 2000 Trigger doesn't work

I am appending records to an SQL Server 2000 database using InfoPath 2007. I made a trigger on the table the form is based on but when I append a new record the trigger never fires. The trigger works fine if I append a new record using Query Analyzer. I first assumed it just would not work due to some...

Posted to Database Integration (Forum) by cduwel on 08-14-2008
Retruning all rather than matching query

Hello, I am new to InfoPath (using the 2003 version) and I have been trying to create master/detail pages from an existing SQL server DB. In trying to learn how to do this I have been using the wonderful example posted by Matt Faus posted at location http://www.infopathdev.com/blogs/matt/archive/2006...

Posted to Database Integration (Forum) by bmcclue on 07-03-2008
Re: A many to one relationship might exist between two tables in the form

LaborSummary Autonumber(Primary Key) CA xxx xxx LaborSummaryCommentsLabor Autonumber(Primary Key) CA_L Comments I have a CA to CA_L relationship setup between the two tables...which will be a one to many.

Posted to Database Integration (Forum) by m181354 on 01-23-2008
Re: A many to one relationship might exist between two tables in the form

I setup my tables and relationships like stated above but get the following error when I create the Data Connection: A many to one relationship might exist between two tables in the form What am I doing wrong?

Posted to Database Integration (Forum) by m181354 on 01-23-2008
Re: SQL Database Question

So the child tables do not have to have a record associated with a record on the parent table to start? I want a one to may relationship where there are no comments to start and users can add as many comments as they want to per Control Account.

Posted to Database Integration (Forum) by m181354 on 01-22-2008
Re: SQL Database Question

This may be my problem...I am using the ID and MainID as the same key on the child table...for the table and for the link to the parent table. ID Name Decription etc 1 Test Testing x 2 Test2 Test Again x Then child MainID Name Comment 2 TestNote Testing is fun

Posted to Database Integration (Forum) by m181354 on 01-22-2008
Re: SQL Database Question

I am using an autonum to create a key on a new record for me on all tables. I have a autonum field records 1 to 3283 on all three tables. My main table have all fields with data in them. My two child tables have the same autonum field filled in 1 to 3283 and also a Control Account Number field. It looks...

Posted to Database Integration (Forum) by m181354 on 01-22-2008
Re: SQL Database Question

I have done that, my Data Connection looks like this... - LaborSummay.dbo - LaborSummayCommentsLabor.dbo - LaborSummayCommentsNonLabor.dbo Autonumber is the primary key for all the tables and I have setup a relationship between the first table listed and the two below it.

Posted to Database Integration (Forum) by m181354 on 01-22-2008
Re: SQL Database Question

My child tables do have a primary key and I have created a relationship between the parent and child tables(autonumber). I used the data connection wizard to setup the new tables. I also fixed some broken bindings. I can receive and submit to the parent table but unable to save to a child table even...

Posted to Database Integration (Forum) by m181354 on 01-22-2008

Page 1 of 2 (15 items) 1 2 Next >