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. Creating a database with many-to-many relationships (21 replies)
  2. AutoNumber - recycle values (5 replies)
  3. Help with deleting duplicate Records (12 replies)
  4. Using Autonumber field as a primary key (10 replies)
  5. Data Modelling question (10 replies)
  6. Lost Linked Tables (10 replies)
  7. Normalization dilemma (12 replies)
  8. Related Tables (7 replies)
  9. Alter table & date format (2 replies)
  10. How would you create a circulating database? (11 replies)
  11. Total newb Q on table structure (32 replies)
  12. link table to external site, eg ftp site? (4 replies)
  13. why am I having such a hard time with this.. normalization probl (8 replies)
  14. Help needed with table design (12 replies)
  15. Library system help (14 replies)
  16. Set default value using SQL DDL query?? (5 replies)
  17. Refresh linked tables at open of database (1 reply)
  18. When to split into 1-1 (23 replies)
  19. Two Primary keys (16 replies)
  20. Join key relationship error (7 replies)
  21. relationship and subdatasheets (11 replies)
  22. Newbie Needs to Set Up a Database (22 replies)
  23. How do I determine table size? (12 replies)
  24. Create a new table using vba code (9 replies)
  25. Normalization Hlelp (15 replies)
  26. Table Lookup (14 replies)
  27. Generating a unique sequence number behind the scenes? (6 replies)
  28. A question on subtypes/supertypes (6 replies)
  29. Error 3022 (11 replies)
  30. Can anyone please explain what this means? (14 replies)
  31. Struggling Rookie (19 replies)
  32. Unable to set the index on a table w/ .seek :( (12 replies)
  33. Autonumber aint Auto (5 replies)
  34. Where to setup calculations in Access tables. (4 replies)
  35. How to strip a hyphen in data (7 replies)
  36. Linking Excel Tables (13 replies)
  37. Onboard the USS IWO JIMA (LHD 7) (6 replies)
  38. Number formatting in Access (20 replies)
  39. Version Control (11 replies)
  40. Default Value to Current Year (7 replies)
  41. zipcode (4 replies)
  42. table of years - std practice (15 replies)
  43. Can you help normalize my design (15 replies)
  44. Proper joins and structure (6 replies)
  45. Table to table lookup (12 replies)
  46. Populating "stocktake" table (6 replies)
  47. Having a little trouble with developing my database (18 replies)
  48. 1 to many relation (26 replies)
  49. Yes/No field (13 replies)
  50. Images (7 replies)
  51. Possible to generate alphanumeric serial numbers? (10 replies)
  52. Split Data (12 replies)
  53. Configuration of Many-to-many building relationship (14 replies)
  54. relinking table to back end (14 replies)
  55. Many to many cascade delete (7 replies)
  56. Find and Replace field names (15 replies)
  57. Normalization: Many to Many Relationships (8 replies)
  58. Table Design for a Data Warehouse (11 replies)
  59. Main form and subform data lookup and relation problem (7 replies)
  60. Visio -> Access -> Visio (1 reply)
  61. Relating a LookUp Table (15 replies)
  62. Splitting 100 columns of data across multiple tables? (10 replies)
  63. Updating Inventory Quantities (17 replies)
  64. Updating default values for existing records (9 replies)
  65. Look Up Table Data Using A Form (22 replies)
  66. organizing the Relationship window (14 replies)
  67. relationship not working (11 replies)
  68. Optimizing the MS Access front end (5 replies)
  69. Want to edit MSysIMEXSpecs and MSysIMEXColumns (import specs) (2 replies)
  70. Combining databases and deleting repeats (7 replies)
  71. Help with Normalization of Database Needed (9 Tables at present) (11 replies)
  72. Removing blank rows from an imported table? (4 replies)
  73. Determine current quarter (3 replies)
  74. Trimming Characters (9 replies)
  75. 'searching' for a record (12 replies)
  76. open adobe at a certain page via a hyperlink (1 reply)
  77. Adding a new table (17 replies)
  78. Why does it take so long for this table to open? (12 replies)
  79. Adding columns to a table in vb. (5 replies)
  80. Am I missing a linking table? (33 replies)
  81. Correct way to set up table? (8 replies)
  82. sub datasheet Name to [NONE] won't stay that way. (15 replies)
  83. Bit of a dilemna with a structure.... (13 replies)
  84. Does Access use index for linked table ? (1 reply)
  85. Multi-Field Primary Key and Null Values (10 replies)
  86. Building a DB for Payroll?!?! (8 replies)
  87. Multiple Currency format for fields. (10 replies)
  88. Moving records from one Table to another (13 replies)
  89. Storing Barcode Information (7 replies)
  90. New Database set-up (10 replies)
  91. Export schema DDL as SQL script (5 replies)
  92. Long Integer Limited to 10 Digits (11 replies)
  93. Auto Number (48 replies)
  94. Delete multiple Tables since Access 2002 (4 replies)
  95. Normalization & relationships (19 replies)
  96. Okay Im at a loss: (88 replies)
  97. Use Make Table Function Without Being Prompted to Confirm Deleti (8 replies)
  98. cascade update related records (6 replies)
  99. difference between inner join and outer join (2 replies)
  100. Getting tables to carry down (19 replies)
  101. DougY or ? - Can you take a look at this table Structure? (16 replies)
  102. Name AutoCorrect Save Failures - just started appearing.. (6 replies)
  103. help on table relationships (15 replies)
  104. MainForm and SubForm Problem (11 replies)
  105. inserting multiple hyperlinks in one field (4 replies)
  106. clearing table data (23 replies)
  107. oracle DESCRIBE TABLE equivalent (4 replies)
  108. A different take on Primary Keys (Don't use Autonumber?) (20 replies)
  109. Row Limit for Access Tables (3 replies)
  110. One-to-many with reciprocity (18 replies)
  111. Normalization Rules (3 replies)
  112. Companies with more than 1 address (26 replies)
  113. Sorting A vs AA: How can I sort A,B,C before A, AA, AB? (6 replies)
  114. Date/Time Field Type. Can it be null or non defined? (10 replies)
  115. Starting out (18 replies)
  116. 2 GB limit workarounds? Strategies for reducing DB size? (3 replies)
  117. SPC database (2 replies)
  118. Datasheet as Data Entry Form (16 replies)
  119. Resources for formats/input masks? (17 replies)
  120. Querys and relationship tables (1 reply)
  121. Identify Duplicates, mark one as master in table? (9 replies)
  122. add new column & fill every row... (6 replies)
  123. Importing Data (11 replies)
  124. Limit Table to One (1) record (4 replies)
  125. Questions and Responses tables (32 replies)
  126. Vendor Table (4 replies)
  127. Structure Questions (17 replies)
  128. Concat for Access? (12 replies)
  129. Cannot find record with the key matching field (5 replies)
  130. Six Characters in Search of a String (66 replies)
  131. Normalization - LOL (22 replies)
  132. pull all records containing Walmart (13 replies)
  133. Change linked table column type (1 reply)
  134. Need to automate importing of Excel files... (13 replies)
  135. Relationships and "Copying" data (14 replies)
  136. Inventory and Sales Transaction Table design Question (2 replies)
  137. One Person, Many Jobs, How to represent (10 replies)
  138. Are my Inventory Control Relationships OK? (22 replies)
  139. Enter new record in many-to-many relation and create linking rec (10 replies)
  140. Unrecognized Database Format (8 replies)
  141. Many-to-Many... How to populate the join table in this instance? (3 replies)
  142. I know this can't be right ... (11 replies)
  143. Sub Total of subform - this should be easy? (15 replies)
  144. ID Fields (19 replies)
  145. Access equivilant of VLookup (from Excel)?? (10 replies)
  146. Boolean field no longer shows a check box (9 replies)
  147. Avalanche records db-advice on relationships (16 replies)
  148. Fill in customer address based upon Customer name (11 replies)
  149. Comparing data in three tables (11 replies)
  150. Table Design (12 replies)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.