Form to review and update records, using multiple combo boxes

[Form to review and update records, cmbos]

In my simple database there are three tables: owners, autos, and repairs, in
which each owner can have multiple autos, and each auto can have multiple
repairs. I want my repairs form to review past repairs data in the repairs
table and accept new data into that table. In combo1 I choose the owner, and
in combo2 I choose the auto after querying the autos table for criteria
ownerID = combo1 selection. It works fine in reviewing data, but when I go
to add a new record, I get the follwing message:

The current field must match the join key <name> in the table that serves as
the 'one' side of one-to-many relationship. (Error 3341).

The one side of the one to many relationship is the AutoID value. Can
anyone tell me why this is not working?

Thanks,
Bill Arthur

 

[Scott L. Heim [MSFT]]

Hi Bill,

How did you setup the relationships between the tables? Do you have
relationships established in the actual database application? If so, can
you successfully add the records in the proper order in that database
application?

When you created your InfoPath form from the database you would have needed
to add the appropriate tables. When you look at your data source Task Pane
(under dataFields) the structure should actually appear as follows:

Owner
Autos
Repairs

If "Autos" is not under "Owner" and "Repairs" is not under "Autos" then the
tables may have been added incorrectly.

Best regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Form to review and update records, cmbos]

I assume you mean checking these in the "Object Dependencies" and they are in
the correct order. Otherwise, I do not know what you mean by data source
task pane. Anyother ideas. Thanks.

 

[Scott L. Heim [MSFT]]

Hi Bill,

With regard to the "Data Source Task Pane", complete these steps:

- Open your InfoPath solution (XSN) in Design View
- From the View menu option, choose Data Source (this should now display
the data source for your form in the Task Pane.)
- I am assuming you built your form from the database so you should see
"dataFields" in the Task Pane - insure they are structured as I described
before.

Best regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Form to review and update records, cmbos]

I am running Access 2003, and am not familiar with Infopath, so am not
following you. Sorry if I am missing some basics here.
Thx.
Bill

 

[Scott L. Heim [MSFT]]

Hi Bill,

No - it is I who should apologize! Since you posted your question to the
"InfoPath" Newsgroup I assumed this was the product in which you were
working. Based on your last post, it sounds as if you are doing everything
in Microsoft Access.

If this is indeed the case, you will be better served posting your question
to the appropriate group.

My apologies for not catching this earlier.

Best regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Form to review and update records, cmbos]

Guess i was in the right pew, wrong church - didn't realize I was in the
Infopath newsgroup. thanks anyways Scott. I'll redirect.