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. Seeking any design/structure advice. (14 replies)
  2. Should I store a field or recompute it? (9 replies)
  3. Development of Access Quality Database (1 reply)
  4. Required Field based on response to another field (1 reply)
  5. Trying To Add Tricky Validation (1 reply)
  6. Unable to delete data (3 replies)
  7. Make the default value the value last inputted (11 replies)
  8. can't create the "one-to-many"relationship and enforce referenci (13 replies)
  9. changing text to date (1 reply)
  10. Adding Fields To A Form (2 replies)
  11. Matching a text in two columns (1 reply)
  12. taking info from a table inserting onto a printable template (2 replies)
  13. Limited duplicate entry (6 replies)
  14. is this a good structure for tables? (6 replies)
  15. Unicode compression (3 replies)
  16. Lost Primary Key (14 replies)
  17. Allow Zero Length and other fields (2 replies)
  18. ALTER table adds column as data type memo instead of text (7 replies)
  19. Split Table? (5 replies)
  20. Complex Query Problem (18 replies)
  21. deleting Parent & Child records together (4 replies)
  22. Replication and Sync (1 reply)
  23. How does one create a foreign key? (3 replies)
  24. Normalizing my Huge table (10 replies)
  25. How to generate an employee cod ein my table (1 reply)
  26. Table Data Type (1 reply)
  27. How big is too big? (3 replies)
  28. Order Quantities? (5 replies)
  29. Delete a ecord (1 reply)
  30. Data_type in field options when importing is locked (1 reply)
  31. TransferSpreadsheet Method and AutoNumber field (3 replies)
  32. Tables and relationships (3 replies)
  33. automatically generate non autonumber primary key (4 replies)
  34. Price Tracker (6 replies)
  35. Can I import tables from another db keeping structure & data (4 replies)
  36. MS Data Access Pages and SQL 2000 Views (2 replies)
  37. How to keep lookup values from changing back to numbers (3 replies)
  38. Table Size when Linking to Oracle (2 replies)
  39. Date of Birth to work out Age (5 replies)
  40. Upgrading to XP - should we split our Access database? (4 replies)
  41. Splitting database and synchronizing data (2 replies)
  42. remove page break symbol in .txt import (7 replies)
  43. Create table from code problem (2 replies)
  44. Help needed in designing a database (3 replies)
  45. How do I get a list of all of my tables in VBA? (3 replies)
  46. Table data drop down lists (3 replies)
  47. Error Question. It used to work!!! (5 replies)
  48. Quick Input Mask question (4 replies)
  49. Relationship between customers in database design (9 replies)
  50. Relationships (2 replies)
  51. need help with tables relationships :-( (5 replies)
  52. Large table - better to store comments in table or link to seper (5 replies)
  53. Format for #s separated with dash (3 replies)
  54. Generate Own Primary Key (8 replies)
  55. automatic update of fields in a table (12 replies)
  56. Multiple Tables to One Table (1 reply)
  57. Advice on design and relationships (10 replies)
  58. Storing and sorting by month/year (5 replies)
  59. normalization problem..help! (7 replies)
  60. Update / append / or merge tables (3 replies)
  61. More questions about tables/relationships (3 replies)
  62. Matching across tables (1 reply)
  63. Linking Tables does not always work the same. Why? (3 replies)
  64. table links (1 reply)
  65. Linking a record in another table from within a Memo field? (2 replies)
  66. Linking tables (6 replies)
  67. Account Number Problem (1 reply)
  68. Change Data type (11 replies)
  69. Missing linked tables (1 reply)
  70. Create Primary Key and format fields (1 reply)
  71. SQL in table (6 replies)
  72. Using Date on multiple tables to link forms (10 replies)
  73. One-To-Many Relationship is Automatically Created (4 replies)
  74. Autonumber issue (5 replies)
  75. Compacting linked tables (1 reply)
  76. How can I create a normalized employee database? (8 replies)
  77. Table design a mess! (9 replies)
  78. Help with structuring my db appropriately (1 reply)
  79. Moving database to network (4 replies)
  80. Reset Table AutoNumber (8 replies)
  81. table normalization (11 replies)
  82. Date as primary key (5 replies)
  83. Reference Number (3 replies)
  84. Table set up help (1 reply)
  85. Multiple relationship from one table to others (6 replies)
  86. Number starting with Zero (3 replies)
  87. appending data (7 replies)
  88. Import pictures and link to data table? (3 replies)
  89. Does it need to be this complex? (10 replies)
  90. AutoNumber default placeholders (11 replies)
  91. Data Export to Excel (1 reply)
  92. relatively simple I think (2 replies)
  93. Setting up Proper Relationships (8 replies)
  94. reservation database (3 replies)
  95. Outputting Tables To Excel In Excess Of 20,000 Records (1 reply)
  96. Split database and now cannot see relationships (6 replies)
  97. Adding field to table Need Relationship (1 reply)
  98. Merge data from two tables (1 reply)
  99. Delete Methodology of the same field in Multiple Tables (2 replies)
  100. No Unique Index when Creating Table Relationship (3 replies)
  101. Relationship/Referential Integrity Problem between 3 tables (3 replies)
  102. Need Running Balance (1 reply)
  103. Cleaning up someone else's Access DB (6 replies)
  104. One-to-many Relationship (3 replies)
  105. Beginner question: how many PKs per table? (7 replies)
  106. Is there a way to convert many fields to from one field type to (3 replies)
  107. advice requested on normalizing structure (3 replies)
  108. Queries (11 replies)
  109. Random Generated number NOT autonumber (8 replies)
  110. Critique my tables please (9 replies)
  111. ODBC Link with over 255 fields (3 replies)
  112. Too many fields, too little time (6 replies)
  113. All part of normalization (6 replies)
  114. Changing a field name and all references to it (2 replies)
  115. Text file from table (7 replies)
  116. Equity Database (5 replies)
  117. Undoing an exclusive lock on a table? (1 reply)
  118. Importing Linked Excel Table Issue (5 replies)
  119. Password Table relationship (2 replies)
  120. Relating Towns to Zip Codes (3 replies)
  121. how to clear a DB (4 replies)
  122. Linked Tables (3 replies)
  123. Indexes in Access databases (10 replies)
  124. calculate the field value using other fields in the same table (5 replies)
  125. Unable To Input Data To Linked Excel Tables (3 replies)
  126. Add Field to Existing Database (2 replies)
  127. Zero as a default value Vs. Null (5 replies)
  128. A different survey database question (19 replies)
  129. Find specific words from table (3 replies)
  130. Export/Copy Relationships (1 reply)
  131. Monthly to Quarterly (4 replies)
  132. How to get "CREATE..." DDL statements for existing tables (6 replies)
  133. Rename Table using VBA - with user input (13 replies)
  134. Backend compact (6 replies)
  135. How Should I Set Up My Tables To Receive And Issue Materials (6 replies)
  136. Import / Export Overflow? (3 replies)
  137. Append table once, no more records (8 replies)
  138. Many to Many Relationships (2 replies)
  139. New column using data from other columns (4 replies)
  140. two controls on a form from the same field of a record (3 replies)
  141. Can a record be related to another record in the same table? (3 replies)
  142. SS# Change.... (3 replies)
  143. Table set-up (12 replies)
  144. linked table is hanging (1 reply)
  145. .mdt file? (4 replies)
  146. FK's; required versus Null values (26 replies)
  147. Import a tab delimited file sometimes appends. (5 replies)
  148. Default value of time. (9 replies)
  149. separate running background update question (6 replies)
  150. Date Format (5 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.