Basic question

  • Thread starter Thread starter hello
  • Start date Start date
H

hello

Can anyone help a newbie .... I have to produce a list of films
currently available for loan. Members can borrow films, only one at a
time though. When a film has been borrow, a tick is put against that
member's field. Also, the details are stored in table 2. I need to be
able to print out all of the films where the film ID doesn't appear in
table 2.


Table 1
Mem_ID
Various fields for contact details
A field that says'Has taken out a film'

Table 2
Mem_ID
Film_ID
Date due back

Table 3
Film_ID
Fields about the film.

I think the easiest solution is to put an extra filed in the film table
that says 'Film_on_loan' and use that in a simple query. What I've been
trying to do is to produce a list of all film IDs that are not in table
2, and use that to produce all the film details in a query using table
3, but can't!

Any pointers?

Cheers
 
Already answered in another newsgroup to which you posted the same question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)

I see you're using Mozilla as your newsread. Unfortunately, I'm not familiar
with that application (any more), but I believe you should be able to type
multiple newsgroup names in the Newsgroups line.

Note that it's generally consider to be A Bad Thing to cross-post to more
than about 2 or 3 newsgroups. (In fact, at
http://www.microsoft.com/presspass/features/2001/Mar01/Mar27pmvp.asp
Microsoft suggests that "One group will suffice")
 
Back
Top