3 Table Conditional Value List

[BeachDave]

I have three tables - RESERVATION, PROPERTY & ISLAND. RESERVATION is related to PROPERTY based on "property id" - in both tables - and PROPERTY is related to ISLAND based on "island id" - in both tables. (There is only one "island id" per "property id" and only one "property id" per "reservation id").

I am trying to create a set of conditional dropdown boxes (based on value lists) on a layout based on the RESERVATION table. The user should choose the island name from dropdown box #1 and then dropdown box #2 would be limited to a list of properties only related to that island.

I have seen the other conditional dropdown / value list posts but can't seem to get this to work for my specific sceneario.

Any help would be appreciated. Let me know if you need more info. b/c I can post if necessary. Thanks.

BeachDave

[Zero Tolerence]

Where exactly are you having problems?

Just create a Value list based off the table occurance that your trying to show, make sure you have "show only related records" checked and it should work.

[BeachDave]

Pop-up menu 1 (for Island) shows all Islands from a value list that is defined to pull the Island id from the Island table - but show the island name so users aren't confused. It is defined to put the Island ID choosen into a Global dummy field in the RESERVATION table as this is not where I want to change the Island ID, rather just use it here to limit the next selection. This seems to work fine.

Popo-up menu 2 (for Property) is defined using a value list that pulls property id from the PROPERTY table (shows property name so users aren't confused). I have this value list set to only show related items from ISLAND. (This value list is defined to put the property id selected into the property id field in the RESERVATION table.)

Like I said the I can select the Island fine, but then the second pop-up menu says .

Any ideas? Thanks. BeachDave