Re: query on project
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 21 May 2008 08:43:18 +0200
Message-ID: <4833c48d$0$14345$e4fe514c@news.xs4all.nl>
Date: Wed, 21 May 2008 08:43:18 +0200
Message-ID: <4833c48d$0$14345$e4fe514c@news.xs4all.nl>
<ellen.van.hagen_at_gmail.com> schreef in bericht
news:0c6c45ac-2316-4030-92a3-bda94817eb00_at_l42g2000hsc.googlegroups.com...
> 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