If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
designing form for inserting records into separate tables
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 TypeW 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. |
Thread Tools | |
Display Modes | |
|
|