This is a multi-part message in MIME format.



------=_NextPart_000_018D_01C06482.8231C600

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Has anybody guidelines for entering data into linked tables.

I was thinking of the same format as we use in forms making life as easy 

as possible.

In forms we create forms and subforms, what would you do in ASP?





Regards

Oliver Dempsey





---

FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

IN YOUR INBOX!

Get the latest and best HTML, XML, and JavaScript tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb's

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

This is a multi-part message in MIME format.



------=_NextPart_000_01C8_01C06486.58A24A40

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Let me make myself a bit clearer.

I want to do this as cleanly and as neatly as possible.

OK, I have a database with several tables:-

tblPropertyOwners

tblProperties

tblRegions

tblCategories



Any owner could own more than one property and a property could fall 

into more than one category.



Would you have a page for AddProperty

and a seperate page and recordset for AddOwner

or is there a way that you could do it like on a form where you can have 

the owner table as part of the main form and the property table would be 

in a subform.

You could then click the down arrow and select an existing owner or move 

to E.O.F in the Owners table and insert a new owner and then move to 

E.O.F. in the Properties table and insert a new property.



What is the cleanest way to do it?





Regards

Oliver Dempsey









---

FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

IN YOUR INBOX!

Get the latest and best HTML, XML, and JavaScript tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb's

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

This is a multi-part message in MIME format.



------=_NextPart_000_002C_01C0653D.3EB16F00

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Does anybody know anything about this type of complicated setup?

Does anybody know where I could read about such stuff???





Regards

Oliver Dempsey







  ----- Original Message -----

  From: Oliver Dempsey

  To: ASP Databases

  Sent: Tuesday, December 12, 2000 9:56 PM

  Subject: [asp_databases] Forms, entering information into linked 

tables





  Let me make myself a bit clearer.

  I want to do this as cleanly and as neatly as possible.

  OK, I have a database with several tables:-

  tblPropertyOwners

  tblProperties

  tblRegions

  tblCategories



  Any owner could own more than one property and a property could fall 

into more than one category.



  Would you have a page for AddProperty

  and a seperate page and recordset for AddOwner

  or is there a way that you could do it like on a form where you can 

have the owner table as part of the main form and the property table 

would be in a subform.

  You could then click the down arrow and select an existing owner or 

move to E.O.F in the Owners table and insert a new owner and then move 

to E.O.F. in the Properties table and insert a new property.



  What is the cleanest way to do it?





  Regards

  Oliver Dempsey





  ---

  FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

  IN YOUR INBOX!

  Get the latest and best HTML, XML, and JavaScript tips, tools, and

  developments from the experts. Sign up for one or more of EarthWeb's

  FREE IT newsletters at http://www.earthweb.com today!



odempsey@b...


leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com







--- 

NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?

Visit EarthWeb for the latest in IT Management, Software Development, 

Web Development, Networking & Communications, and Hardware & Systems.  

Click on http://www.earthweb.com for FREE articles, tutorials,

and discussions from the experts.

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Hi Oliver,



As far as I can see, you have a few options:



If you are targeting an Intranet or an admin-section where you know 

everybody will use IE you can do some nice DHTML things. You could offer 

some input fields for the owner and an "add"button for the properties. Once 

they get clicked, you expose some input fields for the property. You'll 

have extra form fields added dynamically. When you click the button again, 

you add an extra item. Then at the end, all these form fields will be 

submitted to the server where they can be processed at once. Also, on IE 

you could use RDS. With RDS you could access and update the database 

without leaving your page.

All this won't be possible (or at least not easy) in Netscape so this 

depends on your audience.



If you are targeting the Internet, or mixed browsers, then there are some 

other options.

First, have an add button for the property which pops up a new window where 

you can add the properties. When you save / close this window, you can 

reload the first window so the new properties are shown. The same is true 

for the owner: once you save one, the page will reload and show the new owner.

Or you could set up some wizard interface. That is my personal favorite: 

have people enter owner data in the first page, save it to a DB and pass 

along the new ID. In the next page, have them insert an many new properties 

as they want, and connect them to the owner based on the ID. Provide a 

"back" button to go back to the original owner, if they need to change 

something. With your back button (as opposed to the browsers) you'll be 

able to show the new properties on the owner page after you have inserted 

them. By passing along hidden form fields you'll be able to track where you 

are (which page) and what data to show.



For categories I'd provide a separate page. Not sure about your situation, 

but usually categories tend not to change that often, so personally I 

consider this some sort of "system-setting": insert them before you start 

inserting the main records.



Of course there are lots of other solutions as well. I just hope this gives 

you some ideas.





Imar







At 07:45 PM 12/13/2000 +0000, you wrote:

>Does anybody know anything about this type of complicated setup?

>Does anybody know where I could read about such stuff???

>

>

>Regards

>Oliver Dempsey

>

>

>

>>----- Original Message -----

>>From: <mailto:odempsey@b...>Oliver Dempsey

>>To: <mailto:asp_databases@p...>ASP Databases

>>Sent: Tuesday, December 12, 2000 9:56 PM

>>Subject: [asp_databases] Forms, entering information into linked tables

>>

>>Let me make myself a bit clearer.

>>I want to do this as cleanly and as neatly as possible.

>>OK, I have a database with several tables:-

>>tblPropertyOwners

>>tblProperties

>>tblRegions

>>tblCategories

>>

>>Any owner could own more than one property and a property could fall into 

>>more than one category.

>>

>>Would you have a page for AddProperty

>>and a seperate page and recordset for AddOwner

>>or is there a way that you could do it like on a form where you can have 

>>the owner table as part of the main form and the property table would be 

>>in a subform.

>>You could then click the down arrow and select an existing owner or move 

>>to E.O.F in the Owners table and insert a new owner and then move to 

>>E.O.F. in the Properties table and insert a new property.

>>

>>What is the cleanest way to do it?

>>

>>

>>Regards

>>Oliver Dempsey

>>

>>



--- 

NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?

Visit EarthWeb for the latest in IT Management, Software Development, 

Web Development, Networking & Communications, and Hardware & Systems.  

Click on http://www.earthweb.com for FREE articles, tutorials,

and discussions from the experts.

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Hi Imar,

thanks for taking the time to reply to my problem.

That gives me some food for thought and I will certainly have a good look at

your ideas.





Best Regards

Oliver Dempsey







----- Original Message -----

From: Imar Spaanjaars <Imar@S...>

To: ASP Databases <asp_databases@p...>

Sent: Thursday, December 14, 2000 7:51 AM

Subject: [asp_databases] Re: Forms, entering information into linked tables





> Hi Oliver,

>

> As far as I can see, you have a few options:

>

> If you are targeting an Intranet or an admin-section where you know

> everybody will use IE you can do some nice DHTML things. You could offer

> some input fields for the owner and an "add"button for the properties.

Once

> they get clicked, you expose some input fields for the property. You'll

> have extra form fields added dynamically. When you click the button again,

> you add an extra item. Then at the end, all these form fields will be

> submitted to the server where they can be processed at once. Also, on IE

> you could use RDS. With RDS you could access and update the database

> without leaving your page.

> All this won't be possible (or at least not easy) in Netscape so this

> depends on your audience.

>

> If you are targeting the Internet, or mixed browsers, then there are some

> other options.

> First, have an add button for the property which pops up a new window

where

> you can add the properties. When you save / close this window, you can

> reload the first window so the new properties are shown. The same is true

> for the owner: once you save one, the page will reload and show the new

owner.

> Or you could set up some wizard interface. That is my personal favorite:

> have people enter owner data in the first page, save it to a DB and pass

> along the new ID. In the next page, have them insert an many new

properties

> as they want, and connect them to the owner based on the ID. Provide a

> "back" button to go back to the original owner, if they need to change

> something. With your back button (as opposed to the browsers) you'll be

> able to show the new properties on the owner page after you have inserted

> them. By passing along hidden form fields you'll be able to track where

you

> are (which page) and what data to show.

>

> For categories I'd provide a separate page. Not sure about your situation,

> but usually categories tend not to change that often, so personally I

> consider this some sort of "system-setting": insert them before you start

> inserting the main records.

>

> Of course there are lots of other solutions as well. I just hope this

gives

> you some ideas.

>

>

> Imar

>

>

>

> At 07:45 PM 12/13/2000 +0000, you wrote:

> >Does anybody know anything about this type of complicated setup?

> >Does anybody know where I could read about such stuff???

> >

> >

> >Regards

> >Oliver Dempsey

> >

> >

> >

> >>----- Original Message -----

> >>From: <mailto:odempsey@b...>Oliver Dempsey

> >>To: <mailto:asp_databases@p...>ASP Databases

> >>Sent: Tuesday, December 12, 2000 9:56 PM

> >>Subject: [asp_databases] Forms, entering information into linked tables

> >>

> >>Let me make myself a bit clearer.

> >>I want to do this as cleanly and as neatly as possible.

> >>OK, I have a database with several tables:-

> >>tblPropertyOwners

> >>tblProperties

> >>tblRegions

> >>tblCategories

> >>

> >>Any owner could own more than one property and a property could fall

into

> >>more than one category.

> >>

> >>Would you have a page for AddProperty

> >>and a seperate page and recordset for AddOwner

> >>or is there a way that you could do it like on a form where you can have

> >>the owner table as part of the main form and the property table would be

> >>in a subform.

> >>You could then click the down arrow and select an existing owner or move

> >>to E.O.F in the Owners table and insert a new owner and then move to

> >>E.O.F. in the Properties table and insert a new property.

> >>

> >>What is the cleanest way to do it?

> >>

> >>

> >>Regards

> >>Oliver Dempsey

> >>

> >>

>

>

>





--- 

NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?

Visit EarthWeb for the latest in IT Management, Software Development, 

Web Development, Networking & Communications, and Hardware & Systems.  

Click on http://www.earthweb.com for FREE articles, tutorials,

and discussions from the experts.

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com