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. iif table1.field1 = table2.field1 then do this...is this possibl (12 replies)
  2. Updating a date field with a current date when record is saved. (9 replies)
  3. copy Access 2K db (2 replies)
  4. Hours not calculating the correct minutes (6 replies)
  5. Looping through each record in table (9 replies)
  6. Link .snp to table (5 replies)
  7. link .snp to table automatically (5 replies)
  8. Selecting Records From A SubTable (9 replies)
  9. Link Tables Programatically vs Linked Table Manager (2 replies)
  10. Combining like fields (3 replies)
  11. synchronize with autonumber (3 replies)
  12. Passing field names as arguments (3 replies)
  13. Fields().Type (6 replies)
  14. Linking Tables and DB Files (5 replies)
  15. Designing a system to synch 2 databases (with a twist) (10 replies)
  16. Making a table of tables (14 replies)
  17. populate field in table based off other fields (5 replies)
  18. Covert from Text field to Number field help required please (3 replies)
  19. Persistent variables and linked tables (1 reply)
  20. Search a record in a table (2 replies)
  21. Design Flaws (11 replies)
  22. Creating my own autonumber (3 replies)
  23. Really good Question (6 replies)
  24. Removing unused VB code (4 replies)
  25. Calculated field? (3 replies)
  26. Is this possible? (21 replies)
  27. move desktop Access app to another computer (6 replies)
  28. Search for "Part of Field" (2 replies)
  29. SELECTION in List BOXES (1 reply)
  30. if... then... statements in an expression? (7 replies)
  31. How to store an expression in an underlying table (4 replies)
  32. Erasing a table (3 replies)
  33. Strip everything from field after a certain string (6 replies)
  34. Autofill Fields...? (5 replies)
  35. Error: Table already opened exclusively or is already opened... (9 replies)
  36. Basic access stumbling block that is killing me!!! Need Quality (2 replies)
  37. Combining Fields (1 reply)
  38. Relationship advice (not with my wife) (2 replies)
  39. Can I change font colors in the middle of a string? (6 replies)
  40. Storing expressions in tables (2 replies)
  41. Auto Fill Fields (1 reply)
  42. Acess 2K invoice creation relation between invoice and contact l (3 replies)
  43. Database Normalized? (11 replies)
  44. Child Master Field Links (2 replies)
  45. Entire Table Locked - Why? (4 replies)
  46. Metric conversion in Access (7 replies)
  47. split a field (12 replies)
  48. Recordset not updatable (11 replies)
  49. sending SQL results to a Access table (16 replies)
  50. Stupid ? RE: Elapsed Time calculation (4 replies)
  51. Splitting a 1-1 table into 1-M (1 reply)
  52. Serializing and autonumber (3 replies)
  53. Relationship help needed (7 replies)
  54. How can I produce standalone database (17 replies)
  55. how many tables? (73 replies)
  56. <PRE> element and a Memo field (1 reply)
  57. Memo Field (1 reply)
  58. Memo field cutting off (1 reply)
  59. Link Criteria code debugging (2 replies)
  60. How to select specific records from linked tables (3 replies)
  61. circular relationship? (2 replies)
  62. Making a table using VB (1 reply)
  63. Database help (3 replies)
  64. Help tarcking totals (5 replies)
  65. Mailing label (17 replies)
  66. Data Entry and Table design (2 replies)
  67. Limit num of char in Memo field to 500 (2 replies)
  68. Problem with Field Calculation returning #Num! (5 replies)
  69. Can't open any tables suddenly? (3 replies)
  70. Sorting a Text Field in a Numeric Fashion (10 replies)
  71. More Table Design Help (1 reply)
  72. Access excel transfering data through linked tables (1 reply)
  73. Counting text fields (1 reply)
  74. referential integrity - changing data (9 replies)
  75. Export Table from Access to Excel (4 replies)
  76. Linking fields with a Combo Box (3 replies)
  77. Numeric Field Overflow (1 reply)
  78. how to get data to forward fill with zeros (11 replies)
  79. hide table (3 replies)
  80. Quickest Way to remove Duplicate Entries in a table (4 replies)
  81. Combing two field values in a table (9 replies)
  82. Access97 Help with Linked Tables & Indexes (1 reply)
  83. Text field auto fills!!!!!!!!!! (2 replies)
  84. another access (12 replies)
  85. field expressions (3 replies)
  86. linking tables from 2 different DB (3 replies)
  87. Color Change (1 reply)
  88. Access DB over the network (3 replies)
  89. See everything (4 replies)
  90. Normalization Problem with inherited flatfile database (8 replies)
  91. Database do not print mailing labels (3 replies)
  92. entering data!?? (4 replies)
  93. Relationships (3 replies)
  94. Concentatae field based off multiple table entries (3 replies)
  95. What's the best way to keep record items in specified order? (2 replies)
  96. A very obvious answer I'm sure :) (2 replies)
  97. Upsizing error (5 replies)
  98. Generate Email (9 replies)
  99. Make a field act like an autonumber field (1 reply)
  100. Split field (1 reply)
  101. Embed or Link (3 replies)
  102. Kind of new to access, how to roll out your database (4 replies)
  103. Importing Tables from Excel (2 replies)
  104. Copy contents of a field of a record in a table to a variable (3 replies)
  105. Is this table structure sensible? (8 replies)
  106. SendObject - how do I reference a field? (8 replies)
  107. Choosing multiple categories in a field (3 replies)
  108. Silly Question (3 replies)
  109. Command Buttons (1 reply)
  110. can some please convert this to A97 (5 replies)
  111. Passing option box value to second table. (5 replies)
  112. Lookup List - Is it possible?!? (2 replies)
  113. Linking Multiple Reocrds (4 replies)
  114. Change Data Type (1 reply)
  115. The Library Catalog (Bibliographic DB) (1 reply)
  116. Table Design advice (16 replies)
  117. Calulation in Access Field (1 reply)
  118. DB Design and Normalization (5 replies)
  119. Primary Key with Linked TXT file (or not as the case may be!! ) (1 reply)
  120. Prevent autonumber until click button (2 replies)
  121. Linking a table in another database (1 reply)
  122. maximum value from a text field (3 replies)
  123. Link Tables (3 replies)
  124. using logon details in a field (3 replies)
  125. Removing Leading Zeros in Column (5 replies)
  126. Just a quickie (3 replies)
  127. sending email (3 replies)
  128. Comparing the same field in consecutive records (4 replies)
  129. Employee Database (10 replies)
  130. Rename Tbale Field Names? (7 replies)
  131. Normalized Relations Tables (4 replies)
  132. Prevent duplicate record in table (1 reply)
  133. Updating a many to many table (1 reply)
  134. Multiple tables with fewer records vs single table with many nul (18 replies)
  135. Opening another database and finding an entry.. (1 reply)
  136. Problem with Delete SQL statement (deleting from multiple tables (3 replies)
  137. date - julian? (1 reply)
  138. Search two fields (8 replies)
  139. how to code for LISTBOXES!! (2 replies)
  140. autonumber problem (21 replies)
  141. Problem with Data (1 reply)
  142. Using the Null value (4 replies)
  143. Check Linked Tables (1 reply)
  144. Problems with using find features and memo fields (2 replies)
  145. Linking Tables (1 reply)
  146. Table Documentation (10 replies)
  147. text field disabled but need it to "grow" (1 reply)
  148. Setting bound text box default (2 replies)
  149. design problem with nulls (1 reply)
  150. Field Validation (1 reply)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.