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, 72, 73
  1. Help with Normalization of Database Needed (9 Tables at present) (11 replies)
  2. Removing blank rows from an imported table? (4 replies)
  3. Determine current quarter (3 replies)
  4. Trimming Characters (9 replies)
  5. 'searching' for a record (12 replies)
  6. open adobe at a certain page via a hyperlink (1 reply)
  7. Adding a new table (17 replies)
  8. Why does it take so long for this table to open? (12 replies)
  9. Adding columns to a table in vb. (5 replies)
  10. Am I missing a linking table? (33 replies)
  11. Correct way to set up table? (8 replies)
  12. sub datasheet Name to [NONE] won't stay that way. (15 replies)
  13. Bit of a dilemna with a structure.... (13 replies)
  14. Does Access use index for linked table ? (1 reply)
  15. Multi-Field Primary Key and Null Values (10 replies)
  16. Building a DB for Payroll?!?! (8 replies)
  17. Multiple Currency format for fields. (10 replies)
  18. Moving records from one Table to another (13 replies)
  19. Storing Barcode Information (7 replies)
  20. New Database set-up (10 replies)
  21. Export schema DDL as SQL script (5 replies)
  22. Long Integer Limited to 10 Digits (11 replies)
  23. Auto Number (48 replies)
  24. Delete multiple Tables since Access 2002 (4 replies)
  25. Normalization & relationships (19 replies)
  26. Okay Im at a loss: (88 replies)
  27. Use Make Table Function Without Being Prompted to Confirm Deleti (8 replies)
  28. cascade update related records (6 replies)
  29. difference between inner join and outer join (2 replies)
  30. Getting tables to carry down (19 replies)
  31. DougY or ? - Can you take a look at this table Structure? (16 replies)
  32. Name AutoCorrect Save Failures - just started appearing.. (6 replies)
  33. help on table relationships (15 replies)
  34. MainForm and SubForm Problem (11 replies)
  35. inserting multiple hyperlinks in one field (4 replies)
  36. clearing table data (23 replies)
  37. oracle DESCRIBE TABLE equivalent (4 replies)
  38. A different take on Primary Keys (Don't use Autonumber?) (20 replies)
  39. Row Limit for Access Tables (3 replies)
  40. One-to-many with reciprocity (18 replies)
  41. Normalization Rules (3 replies)
  42. Companies with more than 1 address (26 replies)
  43. Sorting A vs AA: How can I sort A,B,C before A, AA, AB? (6 replies)
  44. Date/Time Field Type. Can it be null or non defined? (10 replies)
  45. Starting out (18 replies)
  46. 2 GB limit workarounds? Strategies for reducing DB size? (3 replies)
  47. SPC database (2 replies)
  48. Datasheet as Data Entry Form (16 replies)
  49. Resources for formats/input masks? (17 replies)
  50. Querys and relationship tables (1 reply)
  51. Identify Duplicates, mark one as master in table? (9 replies)
  52. add new column & fill every row... (6 replies)
  53. Importing Data (11 replies)
  54. Limit Table to One (1) record (4 replies)
  55. Questions and Responses tables (32 replies)
  56. Vendor Table (4 replies)
  57. Structure Questions (17 replies)
  58. Concat for Access? (12 replies)
  59. Cannot find record with the key matching field (5 replies)
  60. Six Characters in Search of a String (66 replies)
  61. Normalization - LOL (22 replies)
  62. pull all records containing Walmart (13 replies)
  63. Change linked table column type (1 reply)
  64. Need to automate importing of Excel files... (13 replies)
  65. Relationships and "Copying" data (14 replies)
  66. Inventory and Sales Transaction Table design Question (2 replies)
  67. One Person, Many Jobs, How to represent (10 replies)
  68. Are my Inventory Control Relationships OK? (22 replies)
  69. Enter new record in many-to-many relation and create linking rec (10 replies)
  70. Unrecognized Database Format (8 replies)
  71. Many-to-Many... How to populate the join table in this instance? (3 replies)
  72. I know this can't be right ... (11 replies)
  73. Sub Total of subform - this should be easy? (15 replies)
  74. ID Fields (19 replies)
  75. Access equivilant of VLookup (from Excel)?? (10 replies)
  76. Boolean field no longer shows a check box (9 replies)
  77. Avalanche records db-advice on relationships (16 replies)
  78. Fill in customer address based upon Customer name (11 replies)
  79. Comparing data in three tables (11 replies)
  80. Table Design (12 replies)
  81. Problem with assigning keys in a left join relationship (19 replies)
  82. The search key was not found in any record (8 replies)
  83. ReDesigning DB Assistance with Normalization/Design (11 replies)
  84. Run-time error: '2478' - Access VB - Chicken or Egg (3 replies)
  85. How do you find the name of a relationship? (25 replies)
  86. Making my Dbase reliable for 10 years or so (15 replies)
  87. Send Table to particular worksheet in Excel File (5 replies)
  88. Some very stupid questions (16 replies)
  89. Merge records into one record (15 replies)
  90. input mask email (8 replies)
  91. csv to Access Table (10 replies)
  92. A look over? (18 replies)
  93. Formatting Issue - No value for date field - empty if empty (14 replies)
  94. Autonumber problem (13 replies)
  95. Fitness Training Table (28 replies)
  96. Front End / Back End tables (20 replies)
  97. Staff structure problem (28 replies)
  98. Multiple alter table statements/1 query (3 replies)
  99. Sequential number (10 replies)
  100. See if a table is locked (2 replies)
  101. Setting up database (design) (23 replies)
  102. Membership Database - Invoicing after 365 days (9 replies)
  103. Room booking system (4 replies)
  104. Relationships in a split database (1 reply)
  105. You cannot add or change a record because a related record is re (21 replies)
  106. Best design for performance (13 replies)
  107. tick box auto fills field with date? (11 replies)
  108. Tables and relationships for a specific problem (12 replies)
  109. Jump start on correct way of thinking (17 replies)
  110. Can autonumber be modified to start at a predetermined number? (6 replies)
  111. Basic Question and Answer Field Trouble (14 replies)
  112. Employee Leave Table (3 replies)
  113. validation for dob (14 replies)
  114. Trying to organize relationship/table structures (5 replies)
  115. a question about PK (17 replies)
  116. importing system tables into new db (17 replies)
  117. Table Setup (14 replies)
  118. Build Array in VBA to make a table from (6 replies)
  119. Simple, yet odd question (13 replies)
  120. Join properties and inserting records (13 replies)
  121. Listing of all the States (5 replies)
  122. Too many fields defined. (Error 3190) (2 replies)
  123. Setting default value based on relationship (18 replies)
  124. Structure for HR program -please evaluate (17 replies)
  125. Data Modeling with Generalization Hierarchies (6 replies)
  126. Automating a field in a table (24 replies)
  127. Need to track old data and new data... (21 replies)
  128. Another Normalization (11 replies)
  129. Is it possible to treat consecutive delimiters as one (1 reply)
  130. DB with path UNC (10 replies)
  131. Instant Messaging In Access! (11 replies)
  132. Own consecutive Number (23 replies)
  133. Normalisation and Relationships with Look up Values (17 replies)
  134. Spell Check Just A Field (35 replies)
  135. Combine fields to form Primary key ? (6 replies)
  136. Delete "ImportError" tables (17 replies)
  137. Requesting structure & normalization critique (15 replies)
  138. Insert New Field Into Existing table (11 replies)
  139. "Relationships must be on the same number of fields with the sam (4 replies)
  140. Autonumber and Append (14 replies)
  141. Relationship – individuals and households (16 replies)
  142. Single or Multiple Tables (3 replies)
  143. SQL.INI file error (WIN32 Client : missing configuration file en (1 reply)
  144. normalization (11 replies)
  145. Front End Deletion (34 replies)
  146. Relationships connecting to Autonumbers in a table (Primary and (18 replies)
  147. Advice on best setup... (11 replies)
  148. Is age or gender an attribute of an individual? (14 replies)
  149. Date and Time "Entered" seperated into one table entry (15 replies)
  150. Trouble with relationships (I think) (17 replies)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.