Full Version: Access Tables + Relationships
UtterAccess 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
  1. Yet another attempt at a normalised structure! (16 replies)
  2. Normalisation Check (18 replies)
  3. Converting Text Already in Table to All Uppercase (10 replies)
  4. Autonumber...can I set it? (7 replies)
  5. Table to Values (14 replies)
  6. Track History (Changes) to a Table In another table (11 replies)
  7. Making a Table Autofill a Zip Code by entering a Town Name (6 replies)
  8. Limiting Phone Numbers For Contact Chosen (23 replies)
  9. Table normalization help (13 replies)
  10. Table changes affecting previous data (16 replies)
  11. I have been asked to design a database (31 replies)
  12. Relationship help - coach bookings (12 replies)
  13. Writing Ole & Packaged Objects (7 replies)
  14. Messy Fields- how to seperate the data (20 replies)
  15. Transforming a Massive Spreadsheet into a normalized database (11 replies)
  16. Creating a "auto" number field that counts to 10,000 then resets (10 replies)
  17. Table Data backup (12 replies)
  18. Relationship will only display one-to-one (11 replies)
  19. Customer Orders Database (9 replies)
  20. Enforce referential integrity (17 replies)
  21. Bilateral people relationships (14 replies)
  22. Table Structure (18 replies)
  23. shorten decimal places (6 replies)
  24. Autonumbering a Text Field? (19 replies)
  25. Need some help with table design (11 replies)
  26. Help shift data source to other tables (29 replies)
  27. Importing from Excell problems (12 replies)
  28. DB Structure Question (6 replies)
  29. copy relationships (3 replies)
  30. 10-15 Users, Unable to Split DB - Advice? (10 replies)
  31. Set data type on make-table query? (2 replies)
  32. field character limit for access 2003? (12 replies)
  33. delete query question - "couldn't delete from specified tables" (10 replies)
  34. Creating a random reference number in a record. (68 replies)
  35. Anyone have a football statistics database? (6 replies)
  36. Contract DataBase Design. (10 replies)
  37. I HAVE JUST DELETED 4848 records from my database by accident (11 replies)
  38. DB Structure (18 replies)
  39. Print table design (9 replies)
  40. Import or insert text to numeral (10 replies)
  41. Relationships in a Database for Teachers (10 replies)
  42. Insert New Field Into Existing table (6 replies)
  43. Reset Auto Number Value (5 replies)
  44. Normalization question (13 replies)
  45. Creating a table via VBA, looping over the dictionary info (6 replies)
  46. Finding the location of a linked table (7 replies)
  47. Open Relationships ;) (11 replies)
  48. HELP! Having problems with design (15 replies)
  49. Link MDB Table to ADP Table (8 replies)
  50. 2 detail-tables for 1 order-table? (8 replies)
  51. Unreplicate (8 replies)
  52. Setting default value - same as previous (5 replies)
  53. Table options... (11 replies)
  54. Can't save record because.... (6 replies)
  55. Date and Time Stamp / Calculations Help (4 replies)
  56. Default Value for Primary Key (8 replies)
  57. 2 in 1 field possible (8 replies)
  58. This normalising is bending my head (32 replies)
  59. Tables & relationships - invoicing help (9 replies)
  60. How to add an incrementing counter to a table (5 replies)
  61. name table structure question (3 replies)
  62. Linked Tables (6 replies)
  63. identifying Validation rule violation when appending (5 replies)
  64. Updating Records en Masse (8 replies)
  65. Auto Number Field (6 replies)
  66. How to build this relationship? (11 replies)
  67. Question about validation rule issue (9 replies)
  68. Record Update (8 replies)
  69. Input Mask or Validation Rule, which to use. (1 reply)
  70. relate tables in query (12 replies)
  71. Relationships and Normalizing troubles (16 replies)
  72. Creating a Calendar table (3 replies)
  73. Table Structure Question (5 replies)
  74. Table structure ideas... (5 replies)
  75. I may have messed up an important database - record locks? (11 replies)
  76. "Grade" attribute for a Class Roster database... (8 replies)
  77. BOM Structure (7 replies)
  78. Override auto number? (27 replies)
  79. Multiuser Environment access to tables (9 replies)
  80. Record Change (11 replies)
  81. Social Security Numbers used as identifiers. (8 replies)
  82. validation rule (9 replies)
  83. Related Tables not comunicating (8 replies)
  84. Primary Key (4 replies)
  85. Columns and Concantenation in Queries (7 replies)
  86. Number of Fields in a table. (8 replies)
  87. Trying to work out table relations (again!) (5 replies)
  88. Purchase order > Vendors > Multiple Vendor Addresses > (9 replies)
  89. PO Tracking Number (4 replies)
  90. problem (6 replies)
  91. date & time input mask (14 replies)
  92. relationship problem (13 replies)
  93. Attach Excel sheet - wrong data type (4 replies)
  94. Need Advice on how Involved this Task will be (15 replies)
  95. Teacher wants database to track student attendance (8 replies)
  96. The Trouble with Tables (10 replies)
  97. Trouble creating unique index using multiple fields (4 replies)
  98. refer to another table for a calculation (11 replies)
  99. Problem with structure - help needed (20 replies)
  100. Relationship Question (69 replies)
  101. Self join, junction table or...? (15 replies)
  102. Update all fileds of a table in VBA (4 replies)
  103. Multiple Users - Run Time (7 replies)
  104. Restaurant Reservation Database (8 replies)
  105. Indexing in hindsight (19 replies)
  106. PK Index and relationships automatically being dropped or remove (9 replies)
  107. Access Tables - Combining Fields in a new Field (9 replies)
  108. Exporting fields to another Table (23 replies)
  109. Update Only Current Records (15 replies)
  110. Adding new key values to all tables (10 replies)
  111. Table Modification (5 replies)
  112. Automatically populate form fields (7 replies)
  113. Make table limitation?? (6 replies)
  114. Junction Tables (9 replies)
  115. Database Design (10 replies)
  116. Entering data in table... how do I turn off Access's automatic d (5 replies)
  117. Linking dBase files (6 replies)
  118. Relationship advice haha (10 replies)
  119. Live link from Access Table to Excel (8 replies)
  120. An error occurred when import data from Excel (2 replies)
  121. "Select..Into" causes my field size to change (3 replies)
  122. Have redundant relationships, but don't see any way around it (21 replies)
  123. Rental Database Logic (6 replies)
  124. Spliting One Table into Few Table (18 replies)
  125. Normalizing addresses (8 replies)
  126. Using AutoNumb with data entry (10 replies)
  127. Unique Index Permitting Duplicates (14 replies)
  128. Import From Elaborate Excel Sheet (4 replies)
  129. creating primary key from two fields (21 replies)
  130. Reset ID/Autonumber to 0 (3 replies)
  131. Database design...best way to lay out tables? (10 replies)
  132. installation - deployment help with terminology (3 replies)
  133. max rows in a table (6 replies)
  134. OneToOne Relationship Justified? (24 replies)
  135. Multiple users, split database, mde file, accessing the same tab (4 replies)
  136. Linked table manager (6 replies)
  137. Numbers and Words In A Table (8 replies)
  138. TYPE field in SysObjects?!! (5 replies)
  139. Using DoCmd.GoToRecord , , acNewRec (7 replies)
  140. Copy a table Structure only (8 replies)
  141. Db to count stock (4 replies)
  142. Tricky Date Relationship Problem (11 replies)
  143. event registration using a bar code scanner (7 replies)
  144. linking tables into 1 table (6 replies)
  145. Use ADODB connection + SQL CREATE TABLE statement (4 replies)
  146. Displaying name instead of number (12 replies)
  147. Convert Text Date to Date/Time Format (3 replies)
  148. Link tables on a 97 Access DB within 2000 OS (7 replies)
  149. restart auto number (8 replies)
  150. Normalizing check boxes (11 replies)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.