Hello everyone,
I’m not sure if my situation belongs to a query’s forum. If I have to post it anywhere else I can gladly do it.
I have a situation with a chart/graph. I need to plot a line graph that shows [received] cases vs. [finished] cases. But the [finished] cases have a [status]...
Thanks for the time Mr. B
-quote-
you will have records in the table for entities (persons or companies)
that are not actually your clients.
-/quote-
You are right about that, that issue its been addressed too. But its a
little simpler than this other matter.
I understand the FK concept, but...
I'm creating a legal form that contains:
Case Specifics:
Case Number
Office Number
Court Location
Other Part Lawyer
Lawyer Phone Number
Email
Plaintiff Info:
Name
Address
Phone
email
Defendant Info:
Name
Address
Phone
email
The tables:
tblMain:
tblMainCaseID...
You are right. I tried every combination I could think of just to test
the macro approach but nothing worked for me.
Finally I decided to use a piece of code suggested here and its
working fine.
Thanks to all.
-JC
I have a demographic (tblMain) table with this fields:
- CaseID – AutoNumber
- Name – Text
- Address – Text
- Phone – Text
- NotesID – Number (Linked to tblNotes.NotesID)
In another table (tblNotes), I have:
- NotesID – AutoNumber
- Notes – Memo
In the Main Form I placed a control...