Page 3 of 3 FirstFirst 123
Results 31 to 37 of 37
  1. #31
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521

    Well, to follow standard design, the area field in the Lista de Tarefas table should be Number/Long Integer to match the autonumber field, and the relationships should be on that field, not the descriptive text field.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  2. #32
    slbenfica is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    20
    Quote Originally Posted by pbaldy View Post
    Well, to follow standard design, the area field in the Lista de Tarefas table should be Number/Long Integer to match the autonumber field, and the relationships should be on that field, not the descriptive text field.
    Hello,
    What is the autonumber field? How are the relationships in the text field?
    Thanks

  3. #33
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    See attached
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #34
    slbenfica is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    20
    Quote Originally Posted by pbaldy View Post
    See attached
    But if i change the area field, i can't use the names that i am using...

  5. #35
    slbenfica is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    20
    Hello again,

    How can I solve my problem?

    Thanks

  6. #36
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Have you fixed anything discussed previously? If you want to leave things as they are, you need to save the text value instead of the number.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #37
    slbenfica is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    20
    Hello,

    How do i do it?

    Thanks

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums