cascading combo box problem

[benjammin]

Hi, so I haven't quite figured out this cascading combo box thing based off a query. I can have the first combo propogate to give choices for the second combo but when I go to save the info into the form table nothing shows up?

I have uploaded the file,

http://www.puckscases.com/soars_inventory.accdb

the problem is on frmAddEquipment

What am I missing?

Thanks!

[orange]

Watch these free video tutorials

http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

[benjammin]

I watched those and I understand that but i'm pulling from two different (but related) tables and trying to use those values to write in a third table. It's not so much the cascading part but the part where it actually writes data to the table my form is associated with.

[orange]

I have acc 2003 and can not open accdb.

You profile says 2003, yet you have posted an accdb. How'd you do that?
Can you send an mdb version and I'll look at it.

Ahh: I see your profile has changed between posts??

[benjammin]

Well I switched to an AfterUpdate SQL statement which is now showing the correct values in the second combo box but I'm still unable to write to the form's table. It sends me a

"You cannot add or change a record because a related record is required in table 'tblStation'."

Not quite sure why there has to be a related record... tblEquipment (with field StationID) and tblStation (with field StationID) are related but not mutually exclusive. I have one station to many StationIDs in the tblEquipment.

here's my SQL statement and attached relationship view:

Me.cboStationName.RowSource = "SELECT StationName, SiteID, StationID FROM tblStation " & _
"WHERE tblStation.SiteID = '" & cboSiteName.Value & "' " & _
"ORDER BY tblStation.StationName"

Thanks again!

[benjammin]

I'm pretty sure I updated my profile before I submitted the thread

[June7]

Is 'Enforce referential integrity' checked in the Jointype properties of the table link?

[orange]

I read a post on this subject earlier today, but don't recall the specifics. It had to do with a foreign key. In that case I think the person did not use the Join parameters from the relationships, but created his own.

I think the result (but just a guess) was you have to reset /rebuild the join on the tables involved. I just forget where it was, but I'll take a look.

[benjammin]

Is 'Enforce referential integrity' checked in the Jointype properties of the table link?

DOH, yes and when i removed it guess what happens?

THANKS! SOLVED!

[orange]

DOH, yes and when i removed it guess what happens?

THANKS! SOLVED!

Great.

Here is the post I mentioned earlier (foreign key etc)

http://www.utteraccess.com/forum/Mig...-t1967271.html

[benjammin]

interesting, thanks