Full Version: Access Tables + Relationships
UtterAccess Forums > Microsoft® Access > Access Tables + Relationships
Pages: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70
  1. linking to a view in VBA and making it updatable (6 replies)
  2. How to get a Zero on the end of a decimal (5 replies)
  3. Help, please! (13 replies)
  4. Encrypted or corrupt data in Access database? (2 replies)
  5. Need more help with Table design, relationship and forms (2 replies)
  6. Delete Relationships in External Database (1 reply)
  7. Table design help (26 replies)
  8. Variable data in lookup list (3 replies)
  9. Relationships for customers and all transactions (4 replies)
  10. Saving and showing data in a drop down from a table (3 replies)
  11. Modeling Lists with sub/super-types (11 replies)
  12. How to design the tables - sales version control (1 reply)
  13. Issue with Backend Table not Updating (1 reply)
  14. Relationship - please approve or disapprove - comment etc (4 replies)
  15. Table, Form and Relationship design help for employee education database (7 replies)
  16. Another basic design question (1 reply)
  17. Adding Pull Down Boxes (3 replies)
  18. Oracle DSn and Windows 7 (5 replies)
  19. Crystals_table relinker (7 replies)
  20. display error if field left empty (2 replies)
  21. reset last log in (6 replies)
  22. Items as sub-items (3 replies)
  23. Newbie (very new) - re sub-categories combobox (4 replies)
  24. Attachement Field Type (5 replies)
  25. Natural key or surrogate keys? (9 replies)
  26. How do I make the tables expansion function have more information not shown through re (1 reply)
  27. Need Insights on Database Design (11 replies)
  28. Copying data from linked spreadsheet to another table (1 reply)
  29. Database Design for Shipping (5 replies)
  30. reverting to older Access version (5 replies)
  31. Tables for Companies, Locations, & Contacts - rookie questions (1 reply)
  32. Why use indexed autonumbers? (10 replies)
  33. Relationships Still active after deleting (2 replies)
  34. Inserting a Primary key (2 replies)
  35. Tables and Primary Keys (8 replies)
  36. Tables (3 replies)
  37. Opening form to create new record (and design issues) (5 replies)
  38. Insert record based on another table (7 replies)
  39. Create OpenSession flag on Access Log (11 replies)
  40. 1-1, 1-none vs 1-many relationship, "expert" opinion requested (4 replies)
  41. Setting Minimum Field Sizes (2 replies)
  42. Table wont import to new database (1 reply)
  43. New Project Database for Customer Structure Setup (3 replies)
  44. Displaying and recording information taken from other cells. (2 replies)
  45. Quickly entering values in Multi-value field (2 replies)
  46. Splitting Database (6 replies)
  47. Design advice for Advertising database (14 replies)
  48. HR/Staff Database (1 reply)
  49. Lookup Question - Displaying Both First and Last Names (12 replies)
  50. Autonumber seems to have reset itself (10 replies)
  51. Linking SQL tables uses wrong data type (6 replies)
  52. Comparing tables in Access2007 (12 replies)
  53. Creating a table with dates (2 replies)
  54. delete underlying records in linked table (1 reply)
  55. How to connect many-to-many relationship (18 replies)
  56. Help (1 reply)
  57. Receiving Error 'Referential Integrity Rules Would Be Violated' (3 replies)
  58. One click data upload to other database (1 reply)
  59. Explanation for the following lookup (3 replies)
  60. update table from local temp version to back end table (4 replies)
  61. Normalization Help Toy for Tots (6 replies)
  62. can the relationships window in 2007 be resized (zoomed/shrunk)? (7 replies)
  63. Running total (1 reply)
  64. Difficulty with One to One Relationship between two tables (1 reply)
  65. How to return AND/OR relationships (3 replies)
  66. MySQL to Access (1 reply)
  67. max characters in a text field (20 replies)
  68. Split attached and use as a cascade combo (9 replies)
  69. Another reason why AutoNumbers can't be relied on to be sequential (4 replies)
  70. Sort tables (3 replies)
  71. Why doesn't my input mask work right? (1 reply)
  72. how to break a table to optimize for queries? (3 replies)
  73. How To Change From One-To-Many To A One-To-One (2 replies)
  74. how to update field in second related table (1 reply)
  75. between dates and table design question (4 replies)
  76. Relationships Definition (6 replies)
  77. Access not responding when in datasheet view crash (2 replies)
  78. importing data from csv/xls into multiple tables (14 replies)
  79. Access log (6 replies)
  80. Auto Date Function in Table (2 replies)
  81. Membership Dues Tracking (4 replies)
  82. Copying records to archive table (5 replies)
  83. Need to programmatically drop relationships (5 replies)
  84. Table info for multiple years (3 replies)
  85. Export field to text file (1 reply)
  86. How do I insert null value for a field in a linked table? (3 replies)
  87. automatically link ID field in multiple tables (17 replies)
  88. Error in entering data...primary key, relationship issue?? (4 replies)
  89. Date Format (4 replies)
  90. Breakpoint data macros (4 replies)
  91. Help.... Access 2003 Tables relationship in form and subform (5 replies)
  92. Need Idea's on Importing & Sync'ing Data between 2 Databases (10 replies)
  93. Want to limit size of table - Can I? (3 replies)
  94. Autonumber alternative (1 reply)
  95. Keeping Tracks of Attendants (4 replies)
  96. How to change linked tables programatically ? (8 replies)
  97. Datasheet view Table autonumbercontinues to increments in 1st record entry (3 replies)
  98. Copying data based on a checkbox being ticked (5 replies)
  99. Linking table to Excel (38 replies)
  100. Access Template Downloads (3 replies)
  101. Table Assistance (2 replies)
  102. Autonumbers - a point of clarification (11 replies)
  103. Normalization advise needed please (2 replies)
  104. Input Mask (2 replies)
  105. Relationship Assistance (6 replies)
  106. Where To Define Table Relationships - FrontEnd or BackEnd (4 replies)
  107. update field as sorted (1 reply)
  108. Design Critique Needed (3 replies)
  109. Editing the Asset Web Database table structure (11 replies)
  110. Creating a table to track monthly completion of tasks (3 replies)
  111. Linking Access to Excel- updating in Excel (9 replies)
  112. Create a linked table to hold income data. (3 replies)
  113. one field, several data, possible? (4 replies)
  114. Looking for Design advice (3 replies)
  115. Creating a new query has relationship that isn't defined in relationships (3 replies)
  116. Exporting Relationships to other Access Databases (2 replies)
  117. Linking back end tables to front end (4 replies)
  118. How to list table's field list in a List Box (7 replies)
  119. Overwritting records in a table (2 replies)
  120. populate data into another field after selecting from a dropdown list (7 replies)
  121. Looking for an opinion on this messy table and my idea for a fix... (7 replies)
  122. how to track junctions between several tables (4 replies)
  123. Maximum amount of records allowed in a Table (10 replies)
  124. Having Difficulty With Cascading Delete (3 replies)
  125. Backing up tables via automatic backup icon? (4 replies)
  126. Populating fields (5 replies)
  127. Relationships Not Working (3 replies)
  128. Lookup Field Filter (8 replies)
  129. Relating Tables (3 replies)
  130. Making database to keep track of keys (2 replies)
  131. Please look at my DB (1 reply)
  132. Import, Append Query, Table Layout (10 replies)
  133. not sure how to design my tables (5 replies)
  134. Access 2007 and Degree of Participation Rules (17 replies)
  135. To be or not to be... Redundant?? (5 replies)
  136. Jet database engine cannot find a record in the table (1 reply)
  137. Knowing when to and when not to seperate a table (6 replies)
  138. 2 Lookup Fields using same lookup table - Help (7 replies)
  139. Lookups in tables, forms, and reports (3 replies)
  140. if in field1 combo boxes1 is... than in field2 combo box2 should be...? (15 replies)
  141. Manipulate access table on screen (3 replies)
  142. Running a Report to Show individual Records for One tablel (4 replies)
  143. Newbie and Totally confused, building a 3 tabled database (1 reply)
  144. AutoNumber increments in wide gaps. Impacts forms ability to pull up and display recor (12 replies)
  145. Table Design Question (4 replies)
  146. Table Normalization (2 replies)
  147. Create a multiple value field that retains relational integrity for future SQL upgrade (3 replies)
  148. Calculating fields? (11 replies)
  149. Publications-database, are optional foreign keys an option? (2 replies)
  150. realtime acess to ODBC files (3 replies)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.