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
  1. help with new tables for a fashion matrix of size x colour x qua (9 replies)
  2. Problem with linked ODBC tables (2 replies)
  3. Purchase orders database setup (10 replies)
  4. Pick autonumber start (8 replies)
  5. Join on different field types (6 replies)
  6. Choosing a PK (15 replies)
  7. Entry in a field in a parent automatically going into a filed in (12 replies)
  8. Quick question about an asterisk (15 replies)
  9. Primary Key generated by a formula in Access 2007 (7 replies)
  10. Confusing Relationships (16 replies)
  11. Help for school project (29 replies)
  12. Relationship Troubles (9 replies)
  13. Autonumber Limit? (9 replies)
  14. "locked" table - not updating data (9 replies)
  15. Standard practices. (7 replies)
  16. Importing table information stored as backup (10 replies)
  17. Stuck with database structure (30 replies)
  18. secure a table (20 replies)
  19. Autonumber formatting (14 replies)
  20. Move record from table to table (9 replies)
  21. Servicing database ... adding missed visits (12 replies)
  22. Delete un populated records (5 replies)
  23. tracking vehicle systems - database structure (13 replies)
  24. Shuffle Records? (9 replies)
  25. autonumber stopped working (6 replies)
  26. Edit Linked Table Source (2 replies)
  27. link a frontend to a linked table on the backend (7 replies)
  28. Number of FKs (30 replies)
  29. Annual table "Clean up" (11 replies)
  30. Project Management Tables (12 replies)
  31. Names, Phones, Phone Types (7 replies)
  32. can't enforce referential integrity (2 replies)
  33. Advice needed for project (2 replies)
  34. ODBC Connection to link tables (4 replies)
  35. What is BCNF (5 replies)
  36. Input Mask of a date format (9 replies)
  37. Importing a spaced delimited unfixed width text file via vba (24 replies)
  38. TransferSpreadsheet Import Errors (5 replies)
  39. Need advice on table relationship (13 replies)
  40. How to read normalized records (10 replies)
  41. Tracking subscriptions for Journals and Issues (10 replies)
  42. Comparing Data (23 replies)
  43. missing table since upgrade to access 2003 or 2007 (6 replies)
  44. Relationships not visible (5 replies)
  45. Problems formatting a number as a percent (15 replies)
  46. many to many linking to proper fields (11 replies)
  47. Table question (28 replies)
  48. Validation Rule For Field (7 replies)
  49. add record wth left join (4 replies)
  50. Deleting table data not the actual table structure (11 replies)
  51. A little Bit of Interesting Experience with "SubDataSheets" (10 replies)
  52. Tables linked via DNS Connection (3 replies)
  53. Removing comaas, spaces, slahes, parenthesis, and dashes from fi (9 replies)
  54. Table Lost Primary Key (5 replies)
  55. order by number using text field (5 replies)
  56. Not sure what I'm looking for?... (11 replies)
  57. Structure question around 1 to 1 relationships (9 replies)
  58. Advice on Storing Historical Data per Job (13 replies)
  59. General structure question (10 replies)
  60. Determine in code if a table field has an AutoNumber Data Type (21 replies)
  61. Design Help (8 replies)
  62. Currency is rounding to the nearest dollar! (6 replies)
  63. Database Normalization (15 replies)
  64. Do relationships still need to be set when using autonumber as k (7 replies)
  65. copy values from old record to new one (8 replies)
  66. Expression Builder question (3 replies)
  67. Pass Table parameter to function / sub procedure. (21 replies)
  68. Importing data from Excel (11 replies)
  69. Lost in the Relationship Sauce (10 replies)
  70. Age validation rule (1 reply)
  71. one table multiple relationships (7 replies)
  72. A Scout Camp Database - defining the tables (6 replies)
  73. Link Table Manager (15 replies)
  74. Database Design question (16 replies)
  75. Quoting Database Table's help (6 replies)
  76. Many to many relationships (13 replies)
  77. linking many to many relationship with bridge table (5 replies)
  78. Table is getting too big (3 replies)
  79. passing fields from one table to another (12 replies)
  80. Dealing with data changes (6 replies)
  81. Open OLE object from Table (9 replies)
  82. Design of Tables?! (7 replies)
  83. Code solution needed (11 replies)
  84. concatenating multiple fileds from multiple records (horizontall (14 replies)
  85. Creating a database that mimics a Recipe book (2 replies)
  86. Help needed with addresses (6 replies)
  87. Pros and cons of Linking vs Importing (12 replies)
  88. If You Can Help Plz (7 replies)
  89. Questionnaire Database Design - Questions Table (4 replies)
  90. OLE Object in table (7 replies)
  91. Average a set of scores (8 replies)
  92. Gym booking database (3 replies)
  93. Tables disappearing off left side of Relationships (9 replies)
  94. Prevent Saving Data (automatically) in a Table from a Form (3 replies)
  95. Comments on DB - don't be gentle!!! (10 replies)
  96. Database design suggestions (12 replies)
  97. AutoNumber (16 replies)
  98. relationships (5 replies)
  99. Help with time-dependent database design (14 replies)
  100. Row Level Tracking; necessary or not? (4 replies)
  101. Many types of People in People table? (7 replies)
  102. IP Address Validation Rule (3 replies)
  103. Daily Log Database - Date / Time Question (1 reply)
  104. Check constraint (5 replies)
  105. Record Locking (10 replies)
  106. Check box to numbers (9 replies)
  107. Request for normalization critique (10 replies)
  108. Evils of Access - Part 2 (13 replies)
  109. Normalization and Planning (14 replies)
  110. entering city with , (16 replies)
  111. Adding a Field to a Table (12 replies)
  112. Trouble adding new records (8 replies)
  113. A table of formulas ? (5 replies)
  114. In short, What do table relationships accomplish? (9 replies)
  115. Revising tables in a split database (10 replies)
  116. Advanced Relationships (22 replies)
  117. Recursive Relationships (7 replies)
  118. Financial statement database (1 reply)
  119. Design Question, booleans (11 replies)
  120. Changing Linked Tables properties (6 replies)
  121. Virtual Table to A Table (3 replies)
  122. Normalize confusion (9 replies)
  123. Zipcode table (11 replies)
  124. Importing a DBF file (3 replies)
  125. How to link FE/BE tables via VBA? :) (14 replies)
  126. Table Drop Downs (9 replies)
  127. Structure help (9 replies)
  128. Relating tables/forms to pass the same ID for each district (11 replies)
  129. deleting table links problem (4 replies)
  130. Date problem (8 replies)
  131. use table instead of select case? (20 replies)
  132. reset autonumber (6 replies)
  133. on delete cascade (5 replies)
  134. Sub-table: default record code (7 replies)
  135. How can I set up a relationship between one column and two diffe (14 replies)
  136. linked table manager (11 replies)
  137. are my tables normalized? (8 replies)
  138. Unknown function "Environ".... (9 replies)
  139. NVL from PL/SQL to a MS ACCESS 2002 or MS ACCESS - SQL (2 replies)
  140. tables/primary keys/forms (14 replies)
  141. Can't delete field because of old relationship (3 replies)
  142. Cascade Update/Delete -- Pros/Cons ? (1 reply)
  143. Table Structure (24 replies)
  144. Normalization Question (6 replies)
  145. Contacts table (5 replies)
  146. Error - database engine could not lock table! (10 replies)
  147. Create Table DDL with CASCADE DELETE (7 replies)
  148. Command to edit a record in a table (10 replies)
  149. Combo vs Option group (5 replies)
  150. Encrypt a Table (5 replies)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.