> HI Monte - hows down-under :) Getting better all the time ;-) > > Only by making the primary key = "name,type,location,hnum" instead of "id" > woudl you get a fast normalisation of the data inserted.
You can create an secondary key for those fields and still use your primary key auto-increment field for a foreign key in other tables. Cheers -- Monte Goulding M E R Goulding Software Development Bespoke application development for vertical markets InstallGadget - How to create an installer in 10 seconds revObjective - Making behavior scripts behave _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
