I have two tables: Tenders and Companies. Each record in the tenders table is a tender (contract) between a governmental entity and a company. The tender table has a column "keyword" which is a way to group similar tenders.I'll try to explain my prob...

I'd like to count how many linked records have occurred with another linked record. I have a table where each record is a contract between a company and a governmental entity. The company's column is a linked record and the entity's name is also a li...

I have three tables. People, Companies and a junction table. The junction table shows the relationship between a person and a company. Sometimes, a person is connected to several companies. I’d like to show that relationship. For example, This is Peo...

Hi, I’m having an issue with linking two tables together. I have a ‘Companies’ table and an ‘Employees’ table. In the employees table I have a column named ‘Job Title’ in addition to the column linked to the companies table. My issue is that sometime...

Hi, I have a fairly large database and I was able to build an app based on it. My app is getting attraction thankfully but I have an issue that, if persists, might turn the app useless! The database is in Arabic and performing search in Arabic in Air...