Recent content by dan_man

Hi, I just redesigned the database relationships. I've eliminated circular references and I added some more tables and fields. Please advise Best Regards, Dan

Yes Simon, you're right. The main issue here is the equipment in situ. Unfortunatelly I do not know yet how to solve this issue. As I said in my previous post I am open to any sugestions in order to make this database working.

You're right, I will try to reconfigure the relationships between tables and I will come back with a new srtucture. Do you have any sugestion? I am thinking to define a junction table with Equipment related to each Site. I have to find a way of linking different equipment description with...

Hi All, I am trying to create a database to store Broadcastig transmitters and sites information:banghead:. So far I have tried all possible methods I am aware of to design the same all these without any noticeable result. There are 4 regional centers (DR) each of them managing a number of...

Hi CJ, I am quite new in Access so please be more explicit. Where I have to introduce this code? Thank you for understanding Best Regards, Dan

Hi Eugin, I want to see a list of values corresponding to criteria1=yes when ctiteria 3 is on "yes" and a list of values corresponding to criteria2=yes when criteria 3 is on "no". I am sorry for my bad description but english is not my primary language. Best Regards, Dan

Hi, :banghead: I have a database with two tables structured as in attachement. In a nutshell I have a list of values with two criteria associated in one table and a second table with a 3-rd criteria. What I need is to have a query with a list of values (corresponding to Criteria 1=yes) if...