Hi, I'm building an form allowing users to apply for insurance to cover money stored in business premises. Each applicant may have more than one premises, and each premises may have more than one safe. Because of this, I've built separate tables to store the data on each customer, premises and safe. I've also built a field for the ID number of each customer in the Premises table, and a field for the ID number of each premises in the Safe table. Beyond this, what else must I do to ensure that the data stored in the Premises table relate to the correct customers, and that the data stored in the Safe table relate to the correct premises? Hubert --- Hubert Earl ICQ#: 16199853 My Jamaican Art, Craft & More Online Store: http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html Check out the art print bargains available! Beautiful prints as low as US$7.50 each, less if you purchase 2 or more. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
