Recent content by paliman

  1. P

    How to prevent changes in a main table

    Thank you guys. It was exactly what I wanted
  2. P

    How to prevent changes in a main table

    Hi everybody. I’ve made a database with the following tables (among others): ACCOUNTS AccountCode ShortAccountCode (key) AccountName DIARY HEADERS NumberAD Date Header DIARY DETAIL Id (autonumeric – key) NumberAD (related to the one on the previous table) ShortAccountCode (related to...
  3. P

    Make payments (newbie needs help)

    I'll put an example: Invoice #1: $15 Invoice #2: $ 3 I pay this two invoices with 3 checks, each one for $6 with different due dates. Thanks again
  4. P

    Make payments (newbie needs help)

    I'll put an example: Invoice #1: $15 Invoice #2: $ 3 I pay this two invoices with 3 checks, each one for $6 with different due dates. Thanks again
  5. P

    Make payments (newbie needs help)

    No, no. I write the checks with my old parker and then I enter the data into the db What I need is something like a form with 2 subforms, but I wasn't able to create them because of the relationships. They should be one PO - many invoices one PO - many checks Thanks. I hope it's clear enough.
  6. P

    Make payments (newbie needs help)

    Hi everybody. This is my first post here. I have these 3 tables: Invoice headers Checks Payment orders (2 fields: Number and Date) Tables are related by a field named “PO Num” (payment order number), which is the PO's key. I need to design a procedure to make my payments, something like...
Back
Top Bottom