From: Anne D. on 19 Nov 2009 13:24 Ok so I can breakdown the data from this main table into smaller tables but how do I link them together? My problem is when I am in the main form, I can only pull data from the main table. I need to be able to drop fields from any tables. Thanks,
From: Jeff Boyce on 20 Nov 2009 11:31 The reason I asked for a description of the data was because simply "breaking down the data ... into smaller tables" doesn't necessarily reflect what Access is designed to do. If the terms "relational" and "normalization" are unfamiliar, plan to spend some time working your way up this learning curve. You can use Access on 'sheet data, but both you and Access will end up working overtime to overcome it. You can also use a chainsaw to hammer nails ... but it is neither smart nor a good use of the tool... More info, please... We can't really offer specific suggestions about "how" unless you provide us some specific description of "what". Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Anne D." <AnneD(a)discussions.microsoft.com> wrote in message news:AD139FCA-024E-4CAC-A3FE-9ED019D23999(a)microsoft.com... > Ok so I can breakdown the data from this main table into smaller tables > but > how do I link them together? My problem is when I am in the main form, I > can > only pull data from the main table. I need to be able to drop fields from > any > tables. > Thanks,
First
|
Prev
|
Pages: 1 2 Prev: Button for Open report by Wizard missing Docmd code. Next: Records Count Problem |