[AccessD] Design Problem

Morning Richard!

My approach to this would be to put _all_ Client details into one table and
Job details into another separate table.

The Job table would contain fields for fldClient1, fldClient2, fldClient3,
etc.

HTH - Chris Foote (UK)

> -----Original Message-----
> From: Griffiths, Richard [mailto:R.Griffiths at bury.gov.uk]
> Sent: Monday, November 22, 2004 11:28 AM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Design Problem
> 
> 
> Hi Group
> 
>  
> 
> I am having a brain blockage - can anyone help. I will try to be as
> brief as possible.
> 
> I can't figure out how to design this one.  Seems like 
> different options
> - not sure which way to go.
> 
> Here goes (may not be as complicated as it appears) - sorry 
> its so long.
> 
--------(Snip)--------