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, 129, 130, 131, 132
  1. Changing sort on table, adding autonumber (3 replies)
  2. Multivalue fields (2 replies)
  3. Relationships between 2 tables (9 replies)
  4. Relationship Structure - Insight Requested (22 replies)
  5. One Table w/Two Primary Keys Linked 4x to a Table w/Single Prim (11 replies)
  6. Survey Questions Design (2 replies)
  7. Basic question (relationships) (1 reply)
  8. How to create relationships (5 replies)
  9. Validation rule for a currency field (4 replies)
  10. Inherited a non-normalized database..... (4 replies)
  11. Consolidate fields which only appear in original table (2 replies)
  12. use createfield on linked table (1 reply)
  13. Something is just not quite right (7 replies)
  14. Accessing data in large tables (5 replies)
  15. Data Normalization Quesiton (6 replies)
  16. Change Employee Name to Primary Key (10 replies)
  17. Writing data to tables using DAO (5 replies)
  18. Referencing a recordset field name using a variable (2 replies)
  19. layout (1 reply)
  20. Advice on hoiw to set up a table and/or relationship (5 replies)
  21. Datatypes (3 replies)
  22. Altering Field Precision with VBA (3 replies)
  23. Tracking database changes (11 replies)
  24. Is there a way to create hidden table? (11 replies)
  25. Validation rule for a date field (3 replies)
  26. Linking 2 separate databases (4 replies)
  27. Access Tables and ODBC Links (10 replies)
  28. Auto Update (Tables and forms) (90 replies)
  29. Am I Normalized? (11 replies)
  30. Form with 3 sub forms - not giving the expected results (4 replies)
  31. Saving the value of array to recordset (0 replies)
  32. Linked MySQL View Into Access Issue (7 replies)
  33. Multi-purpose form (5 replies)
  34. password protect a table (3 replies)
  35. Access Database; How big is too big? (12 replies)
  36. Importing from SQL Query Analyzer to a table (0 replies)
  37. Completely Normal? :-) Question about 3NF. (22 replies)
  38. Gotta Design a Large Personnel DB...Help! (2 replies)
  39. Categories of Categories (12 replies)
  40. System fields converting to non-system fields (12 replies)
  41. Linked table problems (9 replies)
  42. Check if table exists through SQL (2 replies)
  43. Many to Many or not... (3 replies)
  44. Multiple entrites in one row to multiple rows. (6 replies)
  45. Creating Relationship between Stock Transactions and Cash dealin (12 replies)
  46. Programmatically Change name of Field (4 replies)
  47. allow duplicate data under certain conditions? (4 replies)
  48. Creating a table on the fly in a multi user environment (3 replies)
  49. Table Normalization Review (2 replies)
  50. Foreign Key Problems (6 replies)
  51. Table and relationship problem (12 replies)
  52. Linking tables (3 replies)
  53. Table and record locking (4 replies)
  54. Index Allowing Duplicates because of Listbox (5 replies)
  55. File with too many fields (8 replies)
  56. Advisor minutes (2 replies)
  57. Flat File Requires Junction Table (5 replies)
  58. Tables & Relationships Q (3 replies)
  59. Simple Table Question (2 replies)
  60. Table Design for Phone Numbers (10 replies)
  61. Input mask for Phone Num and Ext. (7 replies)
  62. Table in use in Access, can't delete (5 replies)
  63. Purchasing Design Concept... Allocation by Product Category Via (1 reply)
  64. Question about relationships in BE and FE (2 replies)
  65. Table structure (1 reply)
  66. Tables with ? (5 replies)
  67. Hyperlink Editing Issue (3 replies)
  68. question about relationships (10 replies)
  69. Normalizing a table (2 replies)
  70. I'm just not seeing it... (5 replies)
  71. Refreshing table data (6 replies)
  72. Plz Help (5 replies)
  73. Capabilities Regarding sharing tables (4 replies)
  74. Conditional Data (12 replies)
  75. Too many fields defined (3 replies)
  76. Table relationship problem... (2 replies)
  77. Disconnect a linked table (3 replies)
  78. Correct Table Design (1 reply)
  79. Error msg. - cannot change record b/c related record required (7 replies)
  80. Only one person can open a split db at a time (2 replies)
  81. Subscript Out of Range Error on Import (1 reply)
  82. Linking tables (3 replies)
  83. Approval Process (1 reply)
  84. Validation rule for letters only text (3 replies)
  85. Having a number increment by one in a table (7 replies)
  86. Table design (6 replies)
  87. Managing Database (1 reply)
  88. Faster join on linked tables? (3 replies)
  89. Dtat type 'double' not big enough (7 replies)
  90. 5 rows into 1 (6 replies)
  91. Dublicate Data (1 reply)
  92. Open dialog only after Table is Closed (10 replies)
  93. Simple Inventory question (4 replies)
  94. Accounts System - Audit trail (needs speeding up!) (4 replies)
  95. Problem that has me stumped. (6 replies)
  96. Baseball Database Relationships (13 replies)
  97. relation ship (2 replies)
  98. using Access to pull informatioin from monster monthly greenbar (1 reply)
  99. Appending selected combo entry to separate table (6 replies)
  100. Any benefit to having 0 VS Null as default value?? (20 replies)
  101. Normalisation of a Number (11 replies)
  102. How to limit a field to only allow values based on previous fiel (9 replies)
  103. Review Database and Request Suggestion (4 replies)
  104. Quickbooks 2007 Premier ODBC (2 replies)
  105. many-to-many issue (1 reply)
  106. Adding records to a table -- copy/paste? But slightly automated? (6 replies)
  107. Correct table structure (1 reply)
  108. Printing (3 replies)
  109. table field type "memo" (17 replies)
  110. Many-to-Many Relationship (3 replies)
  111. My lookup table doesn't work... (3 replies)
  112. Decimal Amount reverting to Zero (5 replies)
  113. Combo Box not Saving Per Record on Form (3 replies)
  114. Simple(?) Lookup Question (1 reply)
  115. two field in one key (4 replies)
  116. Store a calculated value for Inventory? (8 replies)
  117. choosing autonumber beginning (3 replies)
  118. Compare entire records in 2 tables (5 replies)
  119. Modify SQL Server Tables from Access Frontend (8 replies)
  120. Key - unique combination of 3 fields (6 replies)
  121. Trying to Understand Normalization to the 3NF (1 reply)
  122. ODBC Table Link - Read Only (2 replies)
  123. Looking for Recommendations on split tables (3 replies)
  124. Relationship Design for Real Estate Company (3 replies)
  125. Advice on table setup (3 replies)
  126. Import Excel 2003 Spreadsheet into Access Table (3 replies)
  127. Table in BE (3 replies)
  128. Autonumber Out of Sequence (4 replies)
  129. Archiving a detail table and Indexing (14 replies)
  130. Don't want table to autopopulate (3 replies)
  131. Synchronising field name changes in front end and back end (4 replies)
  132. creating tables in a backend mdb (oh,, and then linking to them) (7 replies)
  133. Decimals exporting on number field when I don't want decimals (2 replies)
  134. Locking of database (1 reply)
  135. autotext (3 replies)
  136. Autonumber/Username (concerning PK) (1 reply)
  137. primary key automatically loaded? (1 reply)
  138. Relationship building between one field and four fields in anoth (8 replies)
  139. Converting Number to text or Vise Versa (3 replies)
  140. many-to-many relationship (1 reply)
  141. Autonumber got lost (5 replies)
  142. Internal hyperlink insertion facility disabled (8 replies)
  143. Scheduling Demo (4 replies)
  144. Error 2387 Can't delete the table.... (4 replies)
  145. Sorting a Table with VBA (5 replies)
  146. How to remove dsn's from the list of ODBC machine sources (10 replies)
  147. Table One Record (10 replies)
  148. Locking all records from editing in table (5 replies)
  149. Linked tables (3 replies)
  150. To Grover Park George Deleting Disconnects (3 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.