I'm working on an Access 2007 database. Code is attached.
Brief description of DB -
CommunityPlans (Plans available per Community)
On the Edit Contracts form I need to pick a Property and have the Community displayed automatically and then I need to pick a plan based on the plans available for that community.
I can't figure out how to do this, or what it's even called, hence the ambiguous title. I'm also not sure if Community should be a field in the Properties table, or should I have another table like CommunityProperties?
Any help would be appreciated.