Full Version: Access Tables + Relationships
UtterAccess Discussion 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, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128
  1. Planning hierarchy of database (3 replies)
  2. I know very little about Access so I don't know where to put my question (5 replies)
  3. Which is the "proper" way to design this (16 replies)
  4. Effect of Indexes on file size. (4 replies)
  5. Table-Field property (1 reply)
  6. Table Fields into Text Boxes (3 replies)
  7. Single customer with many transactions (1 reply)
  8. Viewing Relationships (3 replies)
  9. Tables into SQL Server (1 reply)
  10. Autonumber (4 replies)
  11. Restructuring (10 replies)
  12. Make table 2003 to work in 2007 (7 replies)
  13. How do caps at field level? (11 replies)
  14. how to proceed from here in terms of forms and queries (1 reply)
  15. Tables with no relationship question. (6 replies)
  16. getting some basics right ( i hope) (3 replies)
  17. Adding records to a table with decimal places? (6 replies)
  18. Temp Table solution? (2 replies)
  19. Relationships with 'field names'? (9 replies)
  20. Table Relationship Help (25 replies)
  21. Table View problem (1 reply)
  22. Creating a Relationship (13 replies)
  23. Realtime value in a field (2 replies)
  24. Save a variable to be used later on (2 replies)
  25. I split my big table up to separate the MEMO. Mistake? (11 replies)
  26. My Access Auto Auction DB (4 replies)
  27. New Project Help - Relationships etc.. (4 replies)
  28. help with recrdset object -- error 3251 not updtateable (10 replies)
  29. Part Number cross reference for many situations (3 replies)
  30. Is there a different way to link tables via VBA? (5 replies)
  31. How to create a table structure that can store detail values (6 replies)
  32. Designing a Database (9 replies)
  33. Primary key decision - advice appreciated (11 replies)
  34. Relationships - No Unique Index (1 reply)
  35. New Project Help with these fields please (2 replies)
  36. single query using two databases (5 replies)
  37. Tables, Relationships, (3 replies)
  38. Item Container Help (2 replies)
  39. Converting from Access 97 to Access 2002/2003 (2 replies)
  40. Table Structure Set up (15 replies)
  41. Referencing other records from same table within that table (3 replies)
  42. Need Database Help (9 replies)
  43. Input Mask (2 replies)
  44. Type Conversiion Failure (5 replies)
  45. Updating a field based on new info (5 replies)
  46. Tables Detail (5 replies)
  47. Link MS SQL2005 server tables through ODBC (3 replies)
  48. recording staff ID (28 replies)
  49. Automatically creating records (3 replies)
  50. Sample Database if somebody could help (4 replies)
  51. Edit Relationships Dialog Check Boxes grayed out (1 reply)
  52. Data Clipboard (5 replies)
  53. Beginer question (10 replies)
  54. Access 2002 Combine Multiple Records Into One (2 replies)
  55. Getting information from one form into another...kinda. (1 reply)
  56. Primary key - maximum number of fields (16 replies)
  57. contact type issues (2 replies)
  58. Left over lock files (laccdb) (4 replies)
  59. Creating a Table with 2 entries (2 replies)
  60. Issues and ready to pull my hair out (4 replies)
  61. Normalising with multiple languages (1 reply)
  62. Normalising Venue Addresses - Request for suggestions (4 replies)
  63. Best way to link tables together? (11 replies)
  64. One to one Relationships (8 replies)
  65. Table Design: Assistance Required (2 replies)
  66. Finance stocks Tables (5 replies)
  67. Invoice/Payment tables problem (1 reply)
  68. Table structure for many-to-many project and company reference list (2 replies)
  69. How to hide tables created (4 replies)
  70. SAP to 'other' system + mapping table (7 replies)
  71. Primary Key That Can Be Null? (11 replies)
  72. Delete all records from a table (3 replies)
  73. Relationship Problems (17 replies)
  74. unifying multiple inventory types (simple i think) (5 replies)
  75. adding a column import spec (1 reply)
  76. Format a case number Example: 00-00000, I need the dash (6 replies)
  77. programmatically create dbboolean with checkbox? (3 replies)
  78. Copying tables from old BE to new BE, how to deal with referential integrity (4 replies)
  79. Modifying Linked Tables on a Backend programmatically (7 replies)
  80. Create Field from field in other table (20 replies)
  81. First day of the month in the query (3 replies)
  82. Is is possible? (4 replies)
  83. Question about normalizing/structure tables (3 replies)
  84. Many to Many relationship - stuck as 'data violates integrity rules' (13 replies)
  85. how to (3 replies)
  86. Access Estimating or Proposal (1 reply)
  87. Store history of changes (3 replies)
  88. Analysis date table design (6 replies)
  89. Make Table Query using Parameter (4 replies)
  90. Lookup field (9 replies)
  91. Accounting/Forecasting DB (19 replies)
  92. Linking Tables From 97 To 2003 DB (4 replies)
  93. Update one table from another table (36 replies)
  94. Month & Year (2 replies)
  95. Simple Schools Directory Database (5 replies)
  96. Is this 'normalized'? (2 replies)
  97. using access for a bank of medical questions (2 replies)
  98. Normalization and Duplicative Data (2 replies)
  99. Remedial Question (5 replies)
  100. Potential one-to-one relationship? (13 replies)
  101. Deleting/Changing results in 'Value you entered isnt valid for this field' (2 replies)
  102. Relationships Between Tables (2 replies)
  103. When you lock a master row does it lock related child records (1 reply)
  104. Backspace clears text field (4 replies)
  105. import of data from excel (4 replies)
  106. Tables & many to many relationships (57 replies)
  107. the Correct Relationship (14 replies)
  108. The Correct Relationship Revisited (2 replies)
  109. One to Many Table (5 replies)
  110. Creating Form From Relationship Table (3 replies)
  111. Linking data from a master sheet (1 reply)
  112. Validating table field based on query value (1 reply)
  113. Can't Create One-To-One Relationship (12 replies)
  114. Linked table relationships (5 replies)
  115. Lab Sample Storage Database (4 replies)
  116. Table structures (2 replies)
  117. Database of PDF documents? (14 replies)
  118. Converting date formats (3 replies)
  119. Table not updateable in Access 2007 (3 replies)
  120. Question regarding FK. (3 replies)
  121. Rolling 30 Days Add in -1 Point (2 replies)
  122. error message: cannot add record because a related record is needed (13 replies)
  123. linked tables (5 replies)
  124. Multi-User Question (13 replies)
  125. Is it OK to use data as PK in this instance? (7 replies)
  126. Setting up a master/child relationship? (2 replies)
  127. Am I going right in table design and relationship !? Where am I ? (3 replies)
  128. formatting date (4 replies)
  129. Insert A Number Such as 0.15 (1 reply)
  130. AutoNumber (6 replies)
  131. Many-to-Many Relationship with three tables (9 replies)
  132. Junction table off a junction table? (5 replies)
  133. Basic Table Design (21 replies)
  134. Input Mask (6 replies)
  135. combine telephone number with extension (2 replies)
  136. Can autonumber be linked to another field? (6 replies)
  137. Import spec for ODBC visual foxpro table (5 replies)
  138. Importing, Relationships, and Joining problems (1 reply)
  139. Linking two tables (15 replies)
  140. Importing into a database with prior relationships (2 replies)
  141. To-do list database planning question (8 replies)
  142. Combining two tables with respect to each unique record's individual data cells (1 reply)
  143. Collapsing fields (1 reply)
  144. Can't set Cascading Delete (17 replies)
  145. linked tables (1 reply)
  146. Duplicates in a table (7 replies)
  147. Create a defined number of records using a field in a table (2 replies)
  148. 1 vs Multiple Tables (6 replies)
  149. Error Message (1 reply)
  150. relationship question (14 replies)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.