Re: query on project
Date: Wed, 21 May 2008 08:43:18 +0200
<ellen.van.hagen_at_gmail.com> 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