Re: query on project

From: Shakespeare <>
Date: Wed, 21 May 2008 08:43:18 +0200
Message-ID: <4833c48d$0$14345$>

<> schreef in bericht
> Hi there,
> I'm designin a query. I want to join the invoice to a project. In the
> table invoices are record with no project_id or task_id; however when
> i'm looking in the form i see invoices on a project. I can find the
> invoice in the table but with no relation to the project. Can anybody
> shed some light on this relation??

Look for a table that has both invoice_id and project_id. The relation might be modelled with an intermediate table.

Shakespeare Received on Wed May 21 2008 - 01:43:18 CDT

Original text of this message