I am redesigning my db.
Currently I have a table called tblLetterOfCredit.
Within tblLetterOfCRedit are a few different fields.
The fields are called LocalBankName, IssuingBank, AdvisingBank, ConfirmingBank
The fields all have the same lookup:
SELECT tblBanks.BankID, tblBanks.BankName FROM tblBanks ORDER BY tblBanks.BankName;
I am thinking that I can replace these 4 fields with one field called [IssuingBank].
Does this sound like a good idea? I do not believe I should have the four separate fields with each field describing the type of bank it is.