designing form for inserting records into separate tables

Discussion in 'Microsoft Access Database Table Design' started by Masoud, May 17, 2010.

  1. Masoud

    Masoud Guest

    Hello

    I want to design my database for inserting records in 2 separate tables and
    after make search event for searching in both tables and retrieve records.
    Table 1 contains these fields:

    Proj id: 2042
    Field code: COM
    Discipline: MG
    Title: test 1
    Doc Type: PR
    Serial: 0002
    Doc No: concatenated by Proj id+"-"+ Field code+"-"+ Discipline+"-"+ Doc
    Type+"-"+ Serial and result should be some thing: 2042-COM-MG-PR-0002
    Value of Doc No has been made by coding when inserting records in the form.

    Table 2 contains these fields:

    Projid: 2042
    Doc Type:DW
    Unit: 114
    Title:
    Material Code: 1431
    Serial: 0002
    Doc No: Doc Type+"-"+ Projid+"-"+ Unit+"-"+ Material Code+"-"+ Serial and
    result should be some thing like: DW-2042-114-1431-0002
    Value of Doc No has been made by coding when inserting records in the form.
    Now I want to make a form for inserting these records in the tables, how I
    can do it? I mean with 1 form we can do it?
    Also for searching in 2 tables and retrieving records into 1 form what I
    have to do?
    Thanks in advanced.
     
    Masoud, May 17, 2010
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page