Hi , We have come across a slight problem. There is an existing table named 'Material' and it has one foreign key. The foreign key has been named 'FK_MaterialLoc'. The problem is that the foreign key needs to reference two independent columns in two separate tables. The first table is called 'Rack' (column ID:'RackNo') the other, 'User' (column ID:'UserID'). The 'Material' table stores a list of all materials available from both 'Rack' and 'User' tables. So at a time material's location can be either in a rack or with a user. The reason a foreign key is needed to these tables is because there is a 'location' column in the 'Material' table which references the material location, be it in a 'Rack' (column ID:'RackNo') or with a 'User' (column ID:'UserID'). Is it possible to create two references on the fly? Any help on this topic will be GREATLY appreciated
Thanks, Ron ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
