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. Table locks (5 replies)
  2. Hi (8 replies)
  3. Database Noramilization and Speed increase (3 replies)
  4. Relationship Advice (Project Planning) (6 replies)
  5. Getting Totals of Records (2 replies)
  6. Record keeps getting corrupted (1 reply)
  7. List or Combo box lookup tables - Multiple selection? (4 replies)
  8. Ok...I think this is normalized...now how do I build a form off (2 replies)
  9. If A AND B then C Lookup Table Needed (2 replies)
  10. Group level Comments – linking tables and relationships (3 replies)
  11. HELP HELP with Inventory (1 reply)
  12. Making a 1 to 1 relationship (3 replies)
  13. Check Boxes or ManyTypes (7 replies)
  14. How to create dynamic table in run-time? (8 replies)
  15. Separate Different Type Agreements (4 replies)
  16. updating a table (1 reply)
  17. composite keys - to foreign keys (10 replies)
  18. error- property value is too large (3 replies)
  19. Linking with Code (7 replies)
  20. Help Linking Info (3 replies)
  21. field linked to music (2 replies)
  22. data of table stops showing up in form (7 replies)
  23. Creating Table in a different name automatically (7 replies)
  24. Is my Database Normalised? (7 replies)
  25. table blues (3 replies)
  26. Proper Setup for Linking Tables for Club Membership (6 replies)
  27. Many-to-Many Relationships (Is there ever a good reason?) (4 replies)
  28. Linked Table: Possible to make it read only? (4 replies)
  29. How to unhide a table (2 replies)
  30. updating all primary key fields after entry into only 1 table (6 replies)
  31. I am unsure about this table relationship. (1 reply)
  32. Another relationship suffers from my inexperience (17 replies)
  33. Relationship / Table Help (6 replies)
  34. New User needing help with 1st time design of sales/commission d (10 replies)
  35. Normalized structure and data entry... (11 replies)
  36. Change Field Properties (4 replies)
  37. Formatting Numeric Format (1 reply)
  38. primary key must be numerical? (27 replies)
  39. Having required for 4 different fields (4 replies)
  40. I need advice (3 replies)
  41. Linking over Network (3 replies)
  42. Problem with table design for Tree of Diagnosis (16 replies)
  43. Split tables relinked and relationships (3 replies)
  44. Relationships and Normalization Help, Please. (9 replies)
  45. How to delete a relationship in Macro/Module/Command (5 replies)
  46. Time and Attendance Coding database (17 replies)
  47. TransferDatabase acLink (4 replies)
  48. Linked tables... (3 replies)
  49. Lookup Table Question (2 replies)
  50. Enforce Referential Integrity: Don't understand why I can't add (7 replies)
  51. Apply changes to table without losing data? (4 replies)
  52. Normalizing...Get the concept just having a tough time putting i (5 replies)
  53. Category Tables: Do I HAVE to use a FK, can't I just use text? ( (13 replies)
  54. Many Cust have Many Orders (16 replies)
  55. Pivot table data (1 reply)
  56. Sectors and their Sub-Sectors related to an Officer/s...ouch! (11 replies)
  57. Transfer data into Access Database (1 reply)
  58. Inspection Database (4 replies)
  59. Number of Records (2 replies)
  60. Inverse or opposite relationship (3 replies)
  61. Many-Many relationships (I think) (3 replies)
  62. Delete Records with no child (3 replies)
  63. 3nf from the perspective of a Rookie going to far? (16 replies)
  64. Different autonumber allocated dependant on combo box selection (1 reply)
  65. Data input in a form/table bad relationship? (3 replies)
  66. Input masks and optional characters (2 replies)
  67. Linked tables remote database (4 replies)
  68. newbie asking stupid question re: duplicate relationships (1 reply)
  69. Maintaining text formatting in a memo field (4 replies)
  70. Import Specifications vanished (2 replies)
  71. "Random" error on sequential read (5 replies)
  72. Default Value (3 replies)
  73. Table + Form Question (2 replies)
  74. Normalisation again (1 reply)
  75. Review for Normalization (22 replies)
  76. Getting a relationship to be one to many?? (16 replies)
  77. Linked table field data types (4 replies)
  78. Normalisation problem (2 replies)
  79. Seeking any design/structure advice. (14 replies)
  80. Should I store a field or recompute it? (9 replies)
  81. Development of Access Quality Database (1 reply)
  82. Required Field based on response to another field (1 reply)
  83. Trying To Add Tricky Validation (1 reply)
  84. Unable to delete data (3 replies)
  85. Make the default value the value last inputted (11 replies)
  86. can't create the "one-to-many"relationship and enforce referenci (13 replies)
  87. changing text to date (1 reply)
  88. Adding Fields To A Form (2 replies)
  89. Matching a text in two columns (1 reply)
  90. taking info from a table inserting onto a printable template (2 replies)
  91. Limited duplicate entry (6 replies)
  92. is this a good structure for tables? (6 replies)
  93. Unicode compression (3 replies)
  94. Lost Primary Key (14 replies)
  95. Allow Zero Length and other fields (2 replies)
  96. ALTER table adds column as data type memo instead of text (7 replies)
  97. Split Table? (5 replies)
  98. Complex Query Problem (18 replies)
  99. deleting Parent & Child records together (4 replies)
  100. Replication and Sync (1 reply)
  101. How does one create a foreign key? (3 replies)
  102. Normalizing my Huge table (10 replies)
  103. How to generate an employee cod ein my table (1 reply)
  104. Table Data Type (1 reply)
  105. How big is too big? (3 replies)
  106. Order Quantities? (5 replies)
  107. Delete a ecord (1 reply)
  108. Data_type in field options when importing is locked (1 reply)
  109. TransferSpreadsheet Method and AutoNumber field (3 replies)
  110. Tables and relationships (3 replies)
  111. automatically generate non autonumber primary key (4 replies)
  112. Price Tracker (6 replies)
  113. Can I import tables from another db keeping structure & data (4 replies)
  114. MS Data Access Pages and SQL 2000 Views (2 replies)
  115. How to keep lookup values from changing back to numbers (3 replies)
  116. Table Size when Linking to Oracle (2 replies)
  117. Date of Birth to work out Age (5 replies)
  118. Upgrading to XP - should we split our Access database? (4 replies)
  119. Splitting database and synchronizing data (2 replies)
  120. remove page break symbol in .txt import (7 replies)
  121. Create table from code problem (2 replies)
  122. Help needed in designing a database (3 replies)
  123. How do I get a list of all of my tables in VBA? (3 replies)
  124. Table data drop down lists (3 replies)
  125. Error Question. It used to work!!! (5 replies)
  126. Quick Input Mask question (4 replies)
  127. Relationship between customers in database design (9 replies)
  128. Relationships (2 replies)
  129. need help with tables relationships :-( (5 replies)
  130. Large table - better to store comments in table or link to seper (5 replies)
  131. Format for #s separated with dash (3 replies)
  132. Generate Own Primary Key (8 replies)
  133. automatic update of fields in a table (12 replies)
  134. Multiple Tables to One Table (1 reply)
  135. Advice on design and relationships (10 replies)
  136. Storing and sorting by month/year (5 replies)
  137. normalization problem..help! (7 replies)
  138. Update / append / or merge tables (3 replies)
  139. More questions about tables/relationships (3 replies)
  140. Matching across tables (1 reply)
  141. Linking Tables does not always work the same. Why? (3 replies)
  142. table links (1 reply)
  143. Linking a record in another table from within a Memo field? (2 replies)
  144. Linking tables (6 replies)
  145. Account Number Problem (1 reply)
  146. Change Data type (11 replies)
  147. Missing linked tables (1 reply)
  148. Create Primary Key and format fields (1 reply)
  149. SQL in table (6 replies)
  150. Using Date on multiple tables to link forms (10 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.