Search results

  1. W

    Problem with a line graph based on a query

    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]...
  2. W

    Use one table to represent two categories of the same record

    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...
  3. W

    Use one table to represent two categories of the same record

    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...
  4. W

    Pop-up form not showing current record

    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
  5. W

    Pop-up form not showing current record

    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...
Back
Top Bottom