G
Guest
Hello,
I'm having a problem making my database to work. It's a
simple one but my lack of experience in Access is giving
me a hard time.
My database is similar to the NorthWind example, except
that instead of orders it handles legal cases, and
instead of products, each "order" ("case")
handles "lawyers".
I have the following tables
LAWYERS
LAWFIRMS
CASES
CASE-DETAILS: Contains "LawyerID", "CaseID",
and "WorkFor" fields.
CASE-DETAILS is a joint table to merge lawyers and cases
since a lawyer can be assigned to many cases and a case
may have many lawyers assignes (many-to-many rel...).
My problem is with the subform inside CASES-FORM, which
should show lawyers assigned to the displayed case (in
the same way order details shows products on each order
in NorthWind database).This subform should display a drop-
down list for "WorkFor" (opposing or contracting side)
and then FirstName, LastName and CompanyName from LAWYERS
table, linked through LawyerID.
How should I create the form/relationships so the drop-
down field contains all the information together (as
Northwind that shows ProducDescription and Discontinued
when you scroll down products)?
I tried modifying the SQL query but it just got it worse.
Could somebody guide me so I can read further material
about how to do this?
Thank you all in advance for your help.
Jorge
I'm having a problem making my database to work. It's a
simple one but my lack of experience in Access is giving
me a hard time.
My database is similar to the NorthWind example, except
that instead of orders it handles legal cases, and
instead of products, each "order" ("case")
handles "lawyers".
I have the following tables
LAWYERS
LAWFIRMS
CASES
CASE-DETAILS: Contains "LawyerID", "CaseID",
and "WorkFor" fields.
CASE-DETAILS is a joint table to merge lawyers and cases
since a lawyer can be assigned to many cases and a case
may have many lawyers assignes (many-to-many rel...).
My problem is with the subform inside CASES-FORM, which
should show lawyers assigned to the displayed case (in
the same way order details shows products on each order
in NorthWind database).This subform should display a drop-
down list for "WorkFor" (opposing or contracting side)
and then FirstName, LastName and CompanyName from LAWYERS
table, linked through LawyerID.
How should I create the form/relationships so the drop-
down field contains all the information together (as
Northwind that shows ProducDescription and Discontinued
when you scroll down products)?
I tried modifying the SQL query but it just got it worse.
Could somebody guide me so I can read further material
about how to do this?
Thank you all in advance for your help.
Jorge