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, 71, 72
  1. HR/Staff Database (1 reply)
  2. Lookup Question - Displaying Both First and Last Names (12 replies)
  3. Autonumber seems to have reset itself (10 replies)
  4. Linking SQL tables uses wrong data type (6 replies)
  5. Comparing tables in Access2007 (12 replies)
  6. Creating a table with dates (2 replies)
  7. delete underlying records in linked table (1 reply)
  8. How to connect many-to-many relationship (18 replies)
  9. Help (1 reply)
  10. Receiving Error 'Referential Integrity Rules Would Be Violated' (3 replies)
  11. One click data upload to other database (1 reply)
  12. Explanation for the following lookup (3 replies)
  13. update table from local temp version to back end table (4 replies)
  14. Normalization Help Toy for Tots (6 replies)
  15. can the relationships window in 2007 be resized (zoomed/shrunk)? (7 replies)
  16. Running total (1 reply)
  17. Difficulty with One to One Relationship between two tables (1 reply)
  18. How to return AND/OR relationships (3 replies)
  19. MySQL to Access (1 reply)
  20. max characters in a text field (20 replies)
  21. Split attached and use as a cascade combo (9 replies)
  22. Another reason why AutoNumbers can't be relied on to be sequential (4 replies)
  23. Sort tables (3 replies)
  24. Why doesn't my input mask work right? (1 reply)
  25. how to break a table to optimize for queries? (3 replies)
  26. How To Change From One-To-Many To A One-To-One (2 replies)
  27. how to update field in second related table (1 reply)
  28. between dates and table design question (4 replies)
  29. Relationships Definition (6 replies)
  30. Access not responding when in datasheet view crash (2 replies)
  31. importing data from csv/xls into multiple tables (14 replies)
  32. Access log (6 replies)
  33. Auto Date Function in Table (2 replies)
  34. Membership Dues Tracking (4 replies)
  35. Copying records to archive table (5 replies)
  36. Need to programmatically drop relationships (5 replies)
  37. Table info for multiple years (3 replies)
  38. Export field to text file (1 reply)
  39. How do I insert null value for a field in a linked table? (3 replies)
  40. automatically link ID field in multiple tables (17 replies)
  41. Error in entering data...primary key, relationship issue?? (4 replies)
  42. Date Format (4 replies)
  43. Breakpoint data macros (4 replies)
  44. Help.... Access 2003 Tables relationship in form and subform (5 replies)
  45. Need Idea's on Importing & Sync'ing Data between 2 Databases (10 replies)
  46. Want to limit size of table - Can I? (3 replies)
  47. Autonumber alternative (1 reply)
  48. Keeping Tracks of Attendants (4 replies)
  49. How to change linked tables programatically ? (8 replies)
  50. Datasheet view Table autonumbercontinues to increments in 1st record entry (3 replies)
  51. Copying data based on a checkbox being ticked (5 replies)
  52. Linking table to Excel (38 replies)
  53. Access Template Downloads (3 replies)
  54. Table Assistance (2 replies)
  55. Autonumbers - a point of clarification (11 replies)
  56. Normalization advise needed please (2 replies)
  57. Input Mask (2 replies)
  58. Relationship Assistance (6 replies)
  59. Where To Define Table Relationships - FrontEnd or BackEnd (4 replies)
  60. update field as sorted (1 reply)
  61. Design Critique Needed (3 replies)
  62. Editing the Asset Web Database table structure (11 replies)
  63. Creating a table to track monthly completion of tasks (3 replies)
  64. Linking Access to Excel- updating in Excel (9 replies)
  65. Create a linked table to hold income data. (3 replies)
  66. one field, several data, possible? (4 replies)
  67. Looking for Design advice (3 replies)
  68. Creating a new query has relationship that isn't defined in relationships (3 replies)
  69. Exporting Relationships to other Access Databases (2 replies)
  70. Linking back end tables to front end (4 replies)
  71. How to list table's field list in a List Box (7 replies)
  72. Overwritting records in a table (2 replies)
  73. populate data into another field after selecting from a dropdown list (7 replies)
  74. Looking for an opinion on this messy table and my idea for a fix... (7 replies)
  75. how to track junctions between several tables (4 replies)
  76. Maximum amount of records allowed in a Table (10 replies)
  77. Having Difficulty With Cascading Delete (3 replies)
  78. Backing up tables via automatic backup icon? (4 replies)
  79. Populating fields (5 replies)
  80. Relationships Not Working (3 replies)
  81. Lookup Field Filter (8 replies)
  82. Relating Tables (3 replies)
  83. Making database to keep track of keys (2 replies)
  84. Please look at my DB (1 reply)
  85. Import, Append Query, Table Layout (10 replies)
  86. not sure how to design my tables (5 replies)
  87. Access 2007 and Degree of Participation Rules (17 replies)
  88. To be or not to be... Redundant?? (5 replies)
  89. Jet database engine cannot find a record in the table (1 reply)
  90. Knowing when to and when not to seperate a table (6 replies)
  91. 2 Lookup Fields using same lookup table - Help (7 replies)
  92. Lookups in tables, forms, and reports (3 replies)
  93. if in field1 combo boxes1 is... than in field2 combo box2 should be...? (15 replies)
  94. Manipulate access table on screen (3 replies)
  95. Running a Report to Show individual Records for One tablel (4 replies)
  96. Newbie and Totally confused, building a 3 tabled database (1 reply)
  97. AutoNumber increments in wide gaps. Impacts forms ability to pull up and display recor (12 replies)
  98. Table Design Question (4 replies)
  99. Table Normalization (2 replies)
  100. Create a multiple value field that retains relational integrity for future SQL upgrade (3 replies)
  101. Calculating fields? (11 replies)
  102. Publications-database, are optional foreign keys an option? (2 replies)
  103. realtime acess to ODBC files (3 replies)
  104. Searcihng memo data-type with "Append Only" = Yes (1 reply)
  105. Drop-down sort/filter not showing list of entries (12 replies)
  106. Sequence numbers (8 replies)
  107. Can you have one field connected to another? (5 replies)
  108. Trouble Structuring database (3 replies)
  109. Remove empty string from fields (3 replies)
  110. Lock table records while updating (2 replies)
  111. Linking values in one Column to another (16 replies)
  112. Help with initial design (5 replies)
  113. printing field names and Data Type (3 replies)
  114. Change the row color based on a cell value (3 replies)
  115. To spilt a table or not to split a table and how it affects queries and forms (7 replies)
  116. I would like to learn (booking database) (3 replies)
  117. Associating a row with multiple other rows? Is this possible? (2 replies)
  118. puzzled (1 reply)
  119. Update field using SQL statement (4 replies)
  120. Many-to-many relationships - stumped (3 replies)
  121. Error 3341 with multiple related tables (1 reply)
  122. Table structure quandary (10 replies)
  123. Input mask for email address (8 replies)
  124. architecture - land ownership (10 replies)
  125. Combine tables? (1 reply)
  126. Possible To Make Field Non Updateable? (3 replies)
  127. Stopping Access from sorting fields in a Lookup (3 replies)
  128. Alphabetical listing in the LookUp table (2 replies)
  129. get error 3047 when creating table with 7 columns (4 replies)
  130. Simple guide to link a table to a web based form? (1 reply)
  131. not sure if I need a separate table (8 replies)
  132. How do you rank fields in tables? (3 replies)
  133. organize tables and relationship (1 reply)
  134. Can I stop Access autofilling patterns into a table? (2 replies)
  135. Advise please on the design of some new tables (5 replies)
  136. Help designing sheet music database (13 replies)
  137. Importing a table with constraints (4 replies)
  138. Newbie Question: Sorting Numbers versus Text in a Query (5 replies)
  139. Cannot Edit a Field in Design Mode (5 replies)
  140. Access Subdatasheet report (3 replies)
  141. Dmax in design view (2 replies)
  142. Relationships and Normalization Question (5 replies)
  143. Can I find the person who has my table locked? (9 replies)
  144. Update data held within a table (2 replies)
  145. Front End can't Find Back End Table (2 replies)
  146. Items, Building, Room (1 reply)
  147. 0 or 1 to many realtionships (4 replies)
  148. Table Clean Up (5 replies)
  149. Referencing a multivariate value in a table (1 reply)
  150. Help needed using lookup (2 replies)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.