Last post Jun 28, 2008 10:30 AM by mrchonginhk
Jun 28, 2008 05:38 AM|mrchonginhk|LINK
I have a mdb file with 2 tables: A&B
A: Name, City, Checked(Y/N)
B: City, Country
I want to display a Formview that is linked to Table A which display that 2 fields Where the Country = UK and also can edit the records. ..
eg records in A are:
Richard, London, blank
Amy, London, blank
Paul, New York, blank
Guy, Perth, blank
New York, US
I want Formview to display only first 2 records for editing.
How to do it ? Thanks !!
Jun 28, 2008 07:18 AM|Amihai Antebi|LINK
Theres a lot of diffrent ways to do what you ask,
One of the easyest ways, is to use gridview control and linq to sql (but you can use also dataset)
the best way to lern how to do it is by watching those videos that teach you from basic:
Jun 28, 2008 10:30 AM|mrchonginhk|LINK
I actually have FormView setup to edit records in Table A already. That part works fine.
Only part is how to filer and display only those 2 records based on the criteria holding in another table.
Can someone give me an example ?