Certain number determining another fields data..??????? Help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Moderation
    New Member
    • Nov 2015
    • 1

    Certain number determining another fields data..??????? Help

    Hello i'm unsure how to explain this at best.

    I have a table with Area code say, 4302 and that 4302 relates to another field that is suburbs, so 4032 = Yellowvale

    How can i make a validation rule to say when one of these suburb codes is entered, in the other field the suburb affiliated with that code is shown?

    Thank you, im very new to access so apologies.
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    Moderation,
    I would avoid the validation rules if possible here, they can get messing, instead, this essentially the same question as asked here (https://bytes.com/topic/access/answe...ata-validation); therefor, I suggest the same methodology.

    -z

    Comment

    Working...