S. Isaac Dealey wrote: > > create table tship_location ( > locationid varchar(35) primary key, > locationname varchar(25) not null, > locationorder int not null > ) > > create table tship_xref ( > locationid varchar(35) not null, > priceid varchar(35) not null, > shippingcost varchar(25) not null > ) > > alter table tship_xref add > constraint (fk_tship_location) foreign key > references tship_location (locationid),
alter table tship_xref add constraint fk_tship_location foreign key (locationid) references tship_location (locationid) etc. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4