Relational Database ASP Problem

Results 1 to 2 of 2

Thread: Relational Database ASP Problem

  1. #1
    Join Date
    Dec 1969

    Default Relational Database ASP Problem

    My Problem is simple. I have a relational database, and by using a form that connects to several tables I can input booking data for example. I know how to show a table on the web site using ASP, but because my database is relational adding a record to one table is no good, I need a method of adding data to connected tables at once on a single web page, ie enter customer details connecting to the customers table, and on the same page picking a product from the product table, then putting that order in an order table. Is this possible and how hard is it to do? Help!

  2. #2
    Join Date
    Dec 1969

    Default Having a Relational Database is not a problem.

    It is a good thing.<BR><BR><BR>You just need to make sure you are adding the records into the tables in the correct sequence.<BR><BR>I.E.<BR><BR>Table A has one to many Ralationship with Table B, thus no records can exist in B that don&#039t exist in A.<BR><BR>So, then you must add the record to table A before you can add it to B.<BR><BR>I know this sounds obvious, but believe me, it is better to have your db normalized in this manner.<BR><BR><BR>HTH<BR><BR>Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts