Access 2003 and InfoPath2003 forms

[theresa.haynie]

Hi-
I have created a simple form linked to an Access database on a company
server. So far, so good. Can submit and retrieve data. I seem to have
two big issues:
1. On my form, in the detail section, I am now getting the warning
message : Detail not linked to Master. I can't seem to undo that, and
I'm not quite sure how I "broke" the form.

2. When I query, I get all records. Not a problem now, but I soon want
to look for a specific record. If I enter a record EXACTLY as it
exists in the data control field, the record is returned. If I enter
PARTIAL information (say CK61 for a document named CK61 User's Guide),
I get no records.

Any help would be grand!
Thanks

 

[K.Ramana Reddy(GGK Tech)]

Hi,

Did you bind hte master section to the correct columns in the Db?
Fo the second one, SQL will search records based on search parameter
exactly. It will not return records based on partial search parameter.