MS access field dependencies

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • snj3996
    New Member
    • Oct 2006
    • 1

    MS access field dependencies

    I'm trying to create a table that has a field with just two options books and movies. When a user is entering data in the table I would like a different set of fields to appear than if the user had picked blue. For example if i picked books the remaing fields that should appear would ask 1) Publisher 2) Author 3) Year published 4)Price alternatively if I picked movie the fields should be 1)Producer 2)director 3)Distributor 4)Year.
    I'm not sure how exactly to go about doing this any help is appreciated.
    Thanks.
  • PEB
    Recognized Expert Top Contributor
    • Aug 2006
    • 1418

    #2
    Hi,

    This can be done on a Form! In table very difficult!

    Best regards

    Comment

    Working...