Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    New Record (2002)

    My app is a little complex in that you enter quantities in tblServices this consists of a list of services already filled out. A query is used to then show the filled in quantities. This gives part of the line Items that will be posted to tblSalesInvoices-LineItems. These records are then appended to tblSalesInvoiceLineItems-ProForma. A subform shows these records and any expenses are entered which are new records in tblSalesInvoiceLineItems-ProForma.. This arrangement insures extraneous records do not go into tblServices. These records now are appended to tblSalesInvoice-LineItems.
    What is needed is a way to get the new SalesInvoiceID when I transfer the records to tblSalesInvoiceLineItems-ProForma so these records will link with tblSalesInvoice.
    Hope this is not too confusing. Will clarify if needed.
    Frank Hoeffer

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: New Record (2002)

    You'll need to explain what table SalesInvoiceID comes from and what kind of a value it is (autonumber, text, what?) to get an answer. You mention at least 4 tables without indicating which one specifically generates that key, and you're apparently entering data into one table and then copying it at some point to at least one other table. Logically, one would think the key was from tblSalesInvoice, but it sounds like that record hasn't even been created yet, so please clarify.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: New Record (2002)

    when you talk about tblXXXX is this always a table or are you sometimes talking about a form which happens to have picked up the name of its underlying table?
    David Grugeon
    Brisbane Australia

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Record (2002)

    <hr>You'll need to explain what table SalesInvoiceID comes from<hr>
    (tblSalesInvoice-where SalesInvoiceID is the Primary key)
    <hr>and what kind of a value it is (autonumber, text, what?)-<hr>
    Autonumber)
    <hr>to get an answer. You mention at least 4 tables without indicating which one specifically generates that key <hr>
    (tblSalesInvoice)
    <hr>, and you're apparently entering data into one table and then copying it at some point to at least one other table. Logically, one would think the key was from tblSalesInvoice <hr>
    YES,
    <hr>but it sounds like that record hasn't even been created yet, so please clarify.<hr>
    tblCustomers is linked to tblJobs and then to tblSalesInvoice. My client wants tblServices to be used as a sort of fill=in sheet to compute the SalesLineItems. All I need is to create a new record in tblSalesInvoice and then transfer that to the ProForma file. Whne I tried to create a new record it does not do it unless something is entered into a field. I tried sendkeys but get an error.
    Frank

    Edited by Charlotte for clarity

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: New Record (2002)

    This probably feels like an interrogation, but we really try not to <img src=/S/bash.gif border=0 alt=bash width=35 height=39> anyone who's asking for help. The problem is that you know exactly what you're talking about but we have to guess at it.

    If you're letting your client dictate the structure of your database, you will have a hopeless mess on your hands no matter what you build. Your client shouldn't be entering data in table anyhow, so if tblServices is in fact a table rather than a form, your problems start right there. You mentioned a subform and appending records, but you haven't actually explained what is being done. Is the user entering data into a table or a form? Which records are displayed in the subform? Where are you actually entering expenses, in what form or table? Are the append queries being run from code, with a macro or manually? You referred to a "ProForma file". Is that an external file of some kind or were you really referring to a table in the database? If tblServices is a "fill-in" table, then what did you mean by this:
    <hr>This arrangement insures extraneous records do not go into tblServices<hr>
    It sounds like tblServices is a temporary table used to capture data that is then appended to other tables, but that isn't entirely clear.

    If you want to use in-line answers, I suggest you either adopt the fairly standard method of using > signs in front of the quoted text with your answers on a separate line or open the 1-click tagpanel and discover how to use the quote tags as I did when I edited your previous response to make it easier to read. That way anyone browsing the thread can quickly see what's going on and may be able to jump in with some ideas and assistance.
    Charlotte

  6. #6
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Record (2002)

    Hi Charlotte,
    I think the way I'm designing this part is getting a little complicated and hard to communicate. I'm going to redesign it. Will keep you posted.
    Frank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •