🚀 go-pugleaf

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.
>
>