PC Review


Reply
Thread Tools Rate Thread

designing form for inserting records into separate tables

 
 
Masoud
Guest
Posts: n/a
 
      17th May 2010
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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
designing form for inserting records into separate table Masoud Microsoft Access VBA Modules 2 22nd May 2010 07:48 PM
designing form for inserting records into separate table Masoud Microsoft Access Form Coding 0 17th May 2010 12:52 PM
outlook-contacts ... designing forms, need to separate values =?Utf-8?B?bGluZGE=?= Microsoft Outlook Contacts 1 18th Jun 2006 11:52 PM
updating info in separate tables in separate databases timglass via AccessMonster.com Microsoft Access External Data 1 1st Nov 2005 09:20 PM
Inserting records into 2 tables using 1 Stored Proc Carl Microsoft ADO .NET 2 7th Aug 2003 06:41 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:14 AM.