I have a database and I'm trying to make three dropbox on a layout that would show seperate info from the same other table via releation. So here's what I mean.
I have a table named project, in this table I would have three seperate dropbox let's call the product code.
when I choose the first dropbox it would list all the records of the records in my Items list. and show beside the dropbox the info related to this item.
When I choose the second dropbox it would show the same list and show the info beside has the first one. (but when I do that right now the two are changing when I change one.) what I need is to have them seperate I need two different entry from same related table.
Wow I know this sounds like confusing. If you need more info let me know.