Hi,
I have two tables, [Rules] and [Process] which are in a many to many relationship via a junction table[JRule_Process]. It has the following field (relevant ones for this discussion):
[Rules]
RuleID
RuleName
[Process]
ProcessID
ProcessName
[JRule_Process]
JunctionID
RuleID
ProcessID
I have almost 5000 unique [RuleName]...
3 results in 0.0040 seconds.
-
How to return all records (linked and not linked) in the query?
-
Query design - How to design one query which can use different inputs
Hello,
Scenario:
I have list of policies for different countries. What I have done so far is that I have designed a query for each country which will pull out the policies for that country. The report is bases on this query. However, this way I am creating lot of queries.
What I want to do is design a query (and therefore the report) so that I can pull out the policies for a country by simply selecting a name... -
Query design - conceptual question
Hello,
I guess this is a basic question (may sound stupid but happy to get it clarified) so I will match my original scenario and I will try to keep it simple.
I have three tables with following fields:
[Rules]
RuleID - PK
RuleName
[Process]
ProcessID - PK
RuleID - FK
ProcessName
[Risk]
RiskID - PK
ProcessID - FK
RiskName...