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