Article View: borland.public.cppbuilder.database.ado
Article #2759Re: beginner access db questions
From: Rohan
Date: Tue, 01 Apr 2003 21:08
Date: Tue, 01 Apr 2003 21:08
56 lines
2788 bytes
2788 bytes
see the dblookupcombo (or something like that) component Stephane Baillargeon wrote: > Do you know anything about "JOINS" > > Take a look at this site for info > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8 > _qd_09_66b7.asp > > Another way of learning fast is to select SQL view mode in access once your > lookup tables are done. > > "Adam Versteegen" <no@email.com> wrote in message > news:3e5c5521$1@newsgroups.borland.com... > >>Hello, >> >>I have a couple of fairly basic questions about using access databases in >>builder. I've developed plenty of access database app's using just access >>and have plenty of experience with BCB, but have little to no experience >>with using the two together. >> >>First question.... How do I deal with lookup tables between BCB and > > Access? > >>When building tables in Access I can just configure a feild type to lookup >>values in another table. Is this enough to take it over to BCB? In builder >>what do I then have to do to be able to use lookup's? >> >>Second question... If I have a table of people who have tasks to perform > > on > >>given dates. I have a table representing people and I have a table >>representing the tasks. How do I then link the two tables together such > > that > >>I can enter in a number of people and then for each person enter in a > > number > >>of different tasks? >> >>As mentioned, very beginner questions so please be patient :). >> >>Sorry if this is the wrong group, but I figured an ADO group was the best >>group to ask Access questoins. >> >>Vesty. >> >> > > >
Technical Details
Message-ID:
<3e8a00f2@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!out.nntp.be!propagator2-sterling!news-in-sterling.newsfeed.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mailReferences:
<3e5c5521$1@newsgroups.borland.com> <3e650f74@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,36495a059662f921 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-04-01 13:17:37 PST Date: Tue, 01 Apr 2003 16:08:33 -0500 From: Rohan <rohanw@earthlink.net> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: beginner access db questions References: <3e5c5521$1@newsgroups.borland.com> <3e650f74@newsgroups.borland.com> In-Reply-To: <3e650f74@newsgroups.borland.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 24.151.80.186 Message-ID: <3e8a00f2@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1049231602 24.151.80.186 (1 Apr 2003 13:13:22 -0800) Lines: 57 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!out.nntp.be!propagator2-sterling!news-in-sterling.newsfeed.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail