hi, i've created a database to handle an insurance form which deals with the insurance of money. it has a number of different tables such as 'cust', which lists details of customers, 'prem', which lists details of where the money is stored, and 'safe' which lists details of the safes in which the money is stored. the tables 'safe' and 'prem' relate to each other, in that a premises may have one or more safes, and one type of safe may be used in more than one premises. another way of putting it is that each safe could have 1 or more premises that match to it & each premises could have 1 or more safes that match to it, with a maximum number of 3 safes or premises. what structure should i use for the link between the two tables? sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft & More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists