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.
Similar Threads
  1. livia

    designing with tables in a multi-user environment

    livia, Dec 1, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    139
    Duane Hookom
    Dec 2, 2003
  2. Amit

    Need some help in designing tables

    Amit, Mar 1, 2004, in forum: Microsoft Access Database Table Design
    Replies:
    4
    Views:
    157
    Bas Cost Budde
    Mar 3, 2004
  3. Gary

    Help designing Tables

    Gary, May 12, 2004, in forum: Microsoft Access Database Table Design
    Replies:
    3
    Views:
    156
    John Vinson
    May 18, 2004
  4. Pheecaitdj

    While designing a form, the Form View goes blank, Why?

    Pheecaitdj, Sep 5, 2008, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    440
    John W. Vinson
    Sep 5, 2008
  5. tryit

    Store similar types of records all in one table or separate tables?

    tryit, Nov 6, 2009, in forum: Microsoft Access Database Table Design
    Replies:
    2
    Views:
    672
    tryit
    Nov 6, 2009
Loading...

Share This Page