Cascading ComboBox Issue

[Nippy]

Name: CascadingComboError.jpg  Views: 20  Size: 40.8 KB  ID: 15717" class="thumbnail" style="float:CONFIG" />

Setting up cascading ComboBoxes for filtering purposes has been somewhat problematic. When selecting a value from cboModel after choosing the Manufacturer in the frmNewEpirb form, I get the above error.

Has this occurred due to the way my tables are related, the control sources or something else? What have I done wrong?

Thank you.

[ItsMe]

I did not look at your DB but it seems you are trying to save a record (maybe move to another record) before creating another record in another table that is required for referential integrity. Take a look at your relationships window and consider when and where you are saving records or navigating away from a record that was recently created.

[June7]

Also, your forms are based on recordsets that link tables with INNER JOIN. INNER requires related records in both tables on each side of the join for a record to display.

What is an Epirb - emergency beacon? It seems purpose of this db is to inventory/track liferafts and beacons. Can a liferaft have multiple beacons?

A form can enter/edit data for only one table.

Suggest you simplify form RecordSource and/or change the join type.

Just bind frmNewEpirb to tblEpirbs.

The Manufacturer combobox should be UNBOUND because there is no field in tblEpirbs for this value and binding to field from tblEpirbModels attempts to edit record in that table.

There is no reason to include tblManufacturers in the cboModel RowSource.
SELECT EpirbModelPK, EpirbModel FROM tblEpirbModels WHERE ManufacturerFK=[cboManufacturer];
BoundColumn: 1
ColumnWidths: 0";0.5"
ColumnCount: 2
LimitToList: Yes

The LiferaftName combobox is meaningless. There is no field in tblEpirbs for this value.

[ItsMe]

Good catch June, INNER JOIN needs to be reconsidered.

[Nippy]

That resolved it for me — it all makes sense now.

I did some reading on SQL joins and now understand why using INNER wasn't leading to the result I expected in my query.

This has been very helpful. Thanks June!