[AccessD] Table of Names

Stuart McLachlan stuart at lexacorp.com.pg
Thu Apr 28 17:17:12 CDT 2005


On 28 Apr 2005 at 7:56, Susan Harkins wrote:

> Each "type" would be an individual record then. Sounds like you have a many
> to many relationship between your name table and your type table. 
> 

Assuming that there is a type table.  

If Contact, IssuedTo, IssuedBy, ClosedBy, ReleasedBy are fixed fields in 
the main record,  you don't need any intermediate type table or link table, 
just store the PersonID in each field as appropriate.

-- 
Stuart





More information about the AccessD mailing list