Timberwolf
Registered User.
- Local time
- Today, 04:19
- Joined
- Dec 15, 2000
- Messages
- 33
Is it possible to have multiple junction tables refer to the same "lookup table" for their information?
For example, I have a list of funders and a list of projects. I have a junction table of proposals that references the list of projects for which we need funding. I'd also like to create a junction table of grants received that looks up the project on the same list to which the proposals junction table refers. Is this possible?
Thanks so much!
For example, I have a list of funders and a list of projects. I have a junction table of proposals that references the list of projects for which we need funding. I'd also like to create a junction table of grants received that looks up the project on the same list to which the proposals junction table refers. Is this possible?
Thanks so much!