473,385 Members | 1,397 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,385 software developers and data experts.

How to create master detail data entry forms in VWD

I am facing some problem regarding designing of master detail data entry form in vwd,i have vwd 2012 and i have two tables one have primary key and second table have forign key i just want to design web form having primary key table data as master form and forign key table data as detail form(just like grid view).Please halp me how to design a form having single insert update and delete option for both form.

Thansk and Best Regards,
Mar 11 '13 #1
2 2036
Unkno
9
For updating the master content from child that is simple, you write call for foreign table, and move to update the columns in the master from the child.
update mcolumn_name where childforeigncolumn=foreign key
This is just the basic
Mar 11 '13 #2
Thanks for your response.If possible please guide as how i will display/edit/insert/update data in single webform from both table.I just want to display data from parent table as form view and from chield table as detail view.Please note that my requirment is to insert update and delete data on single form.
Thanks.
Mar 11 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Artco News | last post by:
Hi, I was wondering if any of you experts has some example of MySQL data entry form either using PHP or any public domain software for my photo album. I'd like to enter some description with it. ...
5
by: Carlos Ribeiro | last post by:
Hello all, I'm posting this to the list with the intention to form a group of people interested in this type of solution. I'm not going to spam the list with it, unless for occasional and...
0
by: Carlos | last post by:
I’m constructing a Windows Forms application that accesses SQLServer data via a dataset. The dataset contains 2 tables “tblMaster” and “tblDetail” which are related in a one-to-many relationship...
2
by: filbennett | last post by:
Hi Everyone, I'm generally unfamiliar with Access form design, but have programmed Cold Fusion applications for a couple of years. I'd like to build a data entry form in Access that allows the...
2
by: jim Bob | last post by:
Hi, I have a form for data entry and noticed that when i enter data and close the form, there is no warning and it writes directly to the table(s). Is this the default action? Is there a way...
5
by: pw | last post by:
I'm an experienced Access/VBA programmer, trying to become competent using VB.net. Using base vb.net it seems to me to be an AWFUL amount of work to create data-entry forms similar to what one...
12
by: pw | last post by:
I'm an experienced Access/VBA programmer, trying to become competent using VB.net. Using base vb.net it seems to me to be an AWFUL amount of work to create data-entry forms similar to what one...
2
by: manivelk | last post by:
Hi, i want to know how to display the table control at runtime data entry type.. If any one knows plz help me.. Thanks in advance.. Regards, Manivel. K
1
by: vineetbindal | last post by:
Hi all, I have a datagrid and detailsview. when a user selects a row in datagrid onSelectedIndexchanged is fired and Detailsview comes into picture. I want to display the data of the selected row...
3
by: btreddy | last post by:
Hiii experts , I've received one critical requirement from my customer this morning. I've a gridview,in one of my webpage, which displays all the prticipants who are participating in a...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

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.