I have made my invoice as a report as in your last question. The
report does all the calculation I need but it must use the CustomerID
to look up in the extras table what extra activities the customer has
used. There is a foreign key customerIS in extras so this needs to be
searched for and appropriate records displayed so that I can do
calculations relating to them.

Hope thats clear- may need to upload it. Thanks for your help in
previous questions, this is (hopefully) the last one!

Matt

---

Request for Question Clarification by hammer-ga on 18 Apr 2003 04:24 PDT

Hi Matt,

Tell me very specifically what info you need and what you are going to do with it.

- Hammer

---

Clarification of Question by mattie54-ga on 18 Apr 2003 06:37 PDT

Hi,
The extras table looks like this:
ExtrasID

---

Clarification of Question by mattie54-ga on 18 Apr 2003 06:40 PDT

Hi,
The extras table looks like this:
ExtrasID | BookingID | Duration | Type
1             10           4        A
2             16           3        D
3             48           4        L
4             16           3        D
5             10           1        A

I need it so that in my invoice report it must use the current booking
ID (given in one of the fields on the report) and display the extra
activities they used e.g. if the bookingID was 10 I would want it to
display something like:
ExtrasID | Duration | Type
1             4        A
5             1        A

Hope thats clear now. Thanks, matt

---

Clarification of Question by mattie54-ga on 18 Apr 2003 07:10 PDT

Its OK i've done it. thanks though