Message-Id: <10562.112354@fatcity.com> From: "Campbell, James" Date: Wed, 19 Jul 2000 10:10:58 +1000 Subject: Surrogate keys (Oracle list posting) Hi there, I wasn't sure from your posting whether your problem was in defining the foreign key relationship in your schema, or with making ERwin reverse engineer it properly, so I'm assuming it's the latter. If you use the full foreign key syntax in the defiition of your 'child' table - along the lines of "master_sug_key number not null foreign key references master.master_sug_key..." - then ERwin should pick up the reference and build it into its model. ERwin also has the ability to infer relationships while reverse engineering - from memory there's an option labelled something like 'infer relationships based on matching column names' in the reverse engineering options. Let me know if any of this helps. Regards, James Campbell Senior Consultant, Computer Associates Canberra, Australia [This communication expresses my personal opinion. It is not endorsed by my employer, nor by any service provider which transmits it.]