Database designgreenspun.com : LUSENET : DBAzine : One Thread
I have a PAYMENTS table with a RECEIVER field, the problem is that the receiver may come from two different tables: EMPLOYEES and SUPPLIERS. What is the best way to link these tables?
-- Yukio Ito (email@example.com), May 27, 2002
if u r using some frontend application then its simple as:
create table payments with a field RECEIVER_STATUS and RECEIVER_ID ,,now when someone choosed to enter receiver,,he first choose whether it an employee or a supplier,,this will be saved in RECEIVER_STATUS and then correspondingly values from respective table should be populated in combo to be entered in RECEIVER_ID field.
but if u r using backend to manage it ,,then plz do inform me the solution u found ,,and also if u 've still not found any.
-- Muhammad Umar Liaquat (firstname.lastname@example.org), June 19, 2004.