Any access guru's out there?

[Phoenix]

I'm having trouble with an access database and I need a hand.

in database i've got database.primary displaying a drop box of options from primaryL.primary. PrimaryL is also linked to secondaryL.

what I need to do in database is display the secondaryL.secondary options that match the primaryL.primary option chosen in database.primary

Anybody got any ideas?

I managed to get the correct items to show by going

SELECT [secondary] FROM secondaryL WHERE secondaryL.primary= "01 Site Works"

but I can't appear to just say where it is secondaryL.primary = datbase.primary

[abaddonxi]

Thank god I've forgotten the small amount of knowledge I had about access.

Loathsome.


Cheers
Simon

[spudboy]

I am more into Visual Studio and SQL Server, but I can probably sort it out for you if you zip it up and email it to me. If that suits (and as long as the databases are reasonable size that can be emailed) let me know and I will PM you my email address.
Cheers
David

[Phoenix]

it's still being constructed in a can we get this to work kinda way, and it's been a while since I did any access work, so don't laugh, but I would love the help, thankyou

[spudboy]

PM sent with email address.......