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. Am I setting up my tables correctly? (3 replies)
  2. form view (3 replies)
  3. Table structure (1 reply)
  4. Having trouble figuring out my setup (33 replies)
  5. New to Access, can someone check my tables/relationships? (5 replies)
  6. Linking Tables (5 replies)
  7. How is my Tables and Relationship looking? (15 replies)
  8. Creating table relationships based upon partial employee names (1 reply)
  9. Structure Advice required (9 replies)
  10. Custom Auto Number (4 replies)
  11. Excel as backend (4 replies)
  12. Address Relationship not working (14 replies)
  13. Changing the table that a form is based upon (3 replies)
  14. Multiple Users Accessing the Database (7 replies)
  15. Primary key (3 replies)
  16. Memo field gets cut down to 504 chars and prints symbols after (5 replies)
  17. Simple import is not so simple (2 replies)
  18. Are my tables Normalized? (17 replies)
  19. Switch Caption/Field Name View (3 replies)
  20. Critique Requested for New Database (3 replies)
  21. beginner question on relationships (2 replies)
  22. Existing Table Has Duplicate Keys - Can I Repair? (3 replies)
  23. Invoice and InvoiceDetails tables with relationships. (1 reply)
  24. Find blank and replace with 0 (2 replies)
  25. Foreign Key rules (1 reply)
  26. Same Field two tables (1 reply)
  27. Pivot Table based on two tables or a query? (9 replies)
  28. what data type is 0.01%? (6 replies)
  29. Relationships Error (3 replies)
  30. Records Help! (14 replies)
  31. ODBC insert on a linked table xxxx failed (2 replies)
  32. Easiest way to add 100 rows to table (1 reply)
  33. Carrying on information (1 reply)
  34. Linking to added tables (6 replies)
  35. Convert existing table to all caps (9 replies)
  36. tables for a payroll (3 replies)
  37. Create a lookup on a table (5 replies)
  38. Help needed in a plan (10 replies)
  39. Table in Back End (3 replies)
  40. Pictures, OLE in a table or not? (3 replies)
  41. Adding to linked tables (auto numbers) (2 replies)
  42. Transferring Data from one DB to Another (3 replies)
  43. Relationship error message (2 replies)
  44. Table design (3 replies)
  45. Items table and Item Movements Linked By ID not by name!!!!!!! (1 reply)
  46. Difficulty understanding recursive relationship (8 replies)
  47. Why no decimal values show (6 replies)
  48. Correcting Referential Integrity (2 replies)
  49. Can't Link to Tables in an Open DB (1 reply)
  50. Unable to relate tables (3 replies)
  51. Best way to link heriarchy of tables with missing pieces (11 replies)
  52. Avoiding Lookup Tables (7 replies)
  53. Primary Key (5 replies)
  54. lookup field dependent on other field (2 replies)
  55. Missing relationship somewhere... (2 replies)
  56. Relationships (5 replies)
  57. ODBC Links using File DSNs (3 replies)
  58. Modifying Link\Files of Types options (3 replies)
  59. Data Type - Cannot Change (4 replies)
  60. Northwind db- table relationships (4 replies)
  61. FE/BE Best Practices for Network Share (20 replies)
  62. from comma deilited to fixed‐length. (12 replies)
  63. Building a database for gage assignments (4 replies)
  64. Index called ~~temp~index~name0 (1 reply)
  65. AutoNumbering question (7 replies)
  66. Need some help with my new database (6 replies)
  67. Multilanguage Database (1 reply)
  68. New feature in 2007? (2 replies)
  69. suppressing error messages (1 reply)
  70. Entering Ranges into a Table (3 replies)
  71. How to get =b1+b2 (3 replies)
  72. two fields - first is lookup (1 reply)
  73. Room Booking Database (5 replies)
  74. Importing/Linking Tables - Size limit? (5 replies)
  75. Adding a table to a split database (4 replies)
  76. Problem with relationships in a basic database (I imported data (4 replies)
  77. Import into existing table? (4 replies)
  78. Done right? (35 replies)
  79. Where is the TextFormat property? (7 replies)
  80. text field (1 reply)
  81. The best approach? Booking Events and Venues System (4 replies)
  82. Combining Tables (6 replies)
  83. Duplicated Primary Keys Problem (13 replies)
  84. Table structure opinions (3 replies)
  85. 255 Field Limit: is there a way around it? (5 replies)
  86. ResetAutonumber (8 replies)
  87. populating field values (6 replies)
  88. Appending tables (8 replies)
  89. define field width (2 replies)
  90. Call logging DB, relationship problem probably. (5 replies)
  91. Insert Into Table ERROR (4 replies)
  92. Many table not filling out (23 replies)
  93. Review of Tables and Relationships (6 replies)
  94. Related or unrelated data in two tables (3 replies)
  95. Category Conundrum (27 replies)
  96. Create relationship or use lookup field? (5 replies)
  97. Date Field Question (9 replies)
  98. Email address hyperlink field (4 replies)
  99. Question regarding table relationships (1 reply)
  100. JETCOMP.exe (8 replies)
  101. Feedback on table setup (5 replies)
  102. Error Creating Relationship with Referential Integrity (3 replies)
  103. Making linked tables read only (4 replies)
  104. Relationship problem or Form problem? (3 replies)
  105. ID Autonumber Change (2 replies)
  106. Autofill and applying Filters Help - Please be kind to a dumb an (17 replies)
  107. How to structure my tables...? (28 replies)
  108. junction table confusion (13 replies)
  109. Splitting a table based on criteria (2 replies)
  110. Storing and Retrieving Documents (5 replies)
  111. Correcting errors in table (1 reply)
  112. Smart Keys (2 replies)
  113. Junction Table Structure & Entry (2 replies)
  114. Is the following normalization? (15 replies)
  115. One True Lookup Table (15 replies)
  116. easy table question... (3 replies)
  117. Memo Field (1 reply)
  118. Relationship problem ? (3 replies)
  119. Item not Found in Collection (7 replies)
  120. currency and exchange rate (4 replies)
  121. Move data from one table to another (7 replies)
  122. One record, plural relationships to the same table (5 replies)
  123. Circular Relationship Issue? (4 replies)
  124. Importing Dates from a text file into Access 2007 (6 replies)
  125. Table and Relationship Problem (14 replies)
  126. DB Theory Question: Quantities (7 replies)
  127. Relationships and date table (1 reply)
  128. Memo Field Restricted to 255 (14 replies)
  129. Add tables and associate to a ECN Number (18 replies)
  130. After Update Control in a Table? (1 reply)
  131. Table structure puzzle (1 reply)
  132. do I need different table? (1 reply)
  133. Using an archival file (2 replies)
  134. Field in table uses same table as lookup (3 replies)
  135. Tables/Relationship layout (16 replies)
  136. Please review my relationships (3 replies)
  137. Combine Inventory Control with Order Entry (2 replies)
  138. Number Validation need to restrict to 9 digits (2 replies)
  139. Inner Joins and Outer Joins Error (1 reply)
  140. Form with Subform Records - Data Structure (3 replies)
  141. VBA to enter field in table (18 replies)
  142. Having problems with the relaionship between tables (2 replies)
  143. Two versions of one basic database (2 replies)
  144. Relationship problem...normalising arghh! (2 replies)
  145. Basic Record Adding Questions - ACCDB (3 replies)
  146. Too many relationships? (7 replies)
  147. Autonumber (primary key) not numbering in order (4 replies)
  148. Table layout ideas (47 replies)
  149. Cascading Updates (10 replies)
  150. Alter Table Statement on linked table (11 replies)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.