🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

beginner access db questions

#2889
From: Adam Versteegen
Date: Wed, 26 Feb 2003 05:48
24 lines
2017 bytes
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: <3e5c5521$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,36495a059662f921,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-02-25 22:02:45 PST
From: "Adam Versteegen" <no@email.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: beginner access db questions
Date: Wed, 26 Feb 2003 16:48:13 +1100
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 202.44.163.45
Message-ID: <3e5c5521$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1046238497 202.44.163.45 (25 Feb 2003 21:48:17 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail