🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #2759

Re: beginner access db questions

#2759
From: Rohan
Date: Tue, 01 Apr 2003 21:08
56 lines
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-mail
References: <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