473,231 Members | 1,948 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

Best way to Insert related records

Hello,
I have 2 tables tab_1, tab_2
records in tab_1 are related to records in tab_2

i write records to both tables i one step.

e.g. i write record do rec_2 tab_2 , this record have identifier (serial) ,
next i write record (rec_1) to tab_1 which is related to rec_2.
How can i take identifier from rec_2 and write it to rec_1

someone can me help?

Vailor
Jul 19 '05 #1
1 1902
Hello,
I have 2 tables tab_1, tab_2
records in tab_1 are related to records in tab_2

i write records to both tables i one step.

e.g. i write record do rec_2 tab_2 , this record have identifier (serial) ,
next i write record (rec_1) to tab_1 which is related to rec_2.
How can i take identifier from rec_2 and write it to rec_1

someone can me help?

Vailor
I don't have the slightest idea of what you're speaking, i just wanted to contact you because you and i share the same last name. It is a very rare name, and I believe that you and I are in some way related. I am from washington, d.c., and I don't know much about my ancestors. All I know is that I typed my last name in www.google.com, and all these different names started popping up. I've contacted everybody with the same last name, including yourself. Don't worry, I'm not crazy, I just need to find myself, and in order to do that, I have to find out more about my last name.

Crystal Vailor
AKA
thelastvailor :)
Mar 17 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: EricRobineau | last post by:
hello I have a DB with many inter-related tables (MySQL) My main table called "content" has almost only foreign keys (integers) some have a 3 level relation (ex: content->city->region->country) ...
2
by: Tom Gao | last post by:
I have a problem. The project that I'm working on requires me to duplicate records. As in a series of records are entered into the system the user then click on a button to make these as...
3
by: celineusa | last post by:
Hello! Here is part of my database: tblStudents: StudentID tblMajorsAndStudents: StudentID, MajorID tblMajors: MajorID tblMajorsAndClasses: MajorID, ClassID, QuarterTaken tblClasses:...
10
by: jaYPee | last post by:
I have a function that call a stored procedure which performs an insert command. now i want to refresh the dataset so that the newly inserted data will be available to my datagrid I have tried...
7
by: GJPeacock | last post by:
Hi all, Please excuse my limited technical knowledge of PHP, so far i have only created PHP sites using Dreamweaver, i find know that i need features outside of it's capabilities. I am trying...
2
by: Bob | last post by:
I got three related datagrid views one parent and two children of the same. The two child tables contain many thousands of records and some of the contents are bitmap files in a sql server...
0
by: David | last post by:
Hi, I've been using MS Access as a front end to our remote MySQL db for a long time. I've just added a facility for clients to select a record to copy along with all its sub-records. The...
2
by: David | last post by:
Hi, I have a MySQL database linked to an MS Access front-end. I have an app which works fine with the local copy of the Access DB, but when run with the linked tables for MySQL, it fails. ...
1
by: Muchach | last post by:
Hello, Ok so what I've got going on is a form that is populated by pulling info from database then using php do{} to create elements in form. I have a text box in each table row for the user to...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.