Hello "piltdown", (real names would be nice)
> Is it possible to have a field in one table obtain its value from another > field in a different table. For example, a table containing parts ordered > may contain a supplier field whose data is stored in a Suppliers table. Andrew already described the DB structure you would use on this. For the GUI, if you want to enter data into this structure, you would usually use a list box in a form. When entering data into the table(s) directly, there is no such lookup feature. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
