3 tables (mdb) and ASP ? Some solution?

Results 1 to 2 of 2

Thread: 3 tables (mdb) and ASP ? Some solution?

  1. #1
    dove g Guest

    Default 3 tables (mdb) and ASP ? Some solution?

    I have one DB in Access 2000.<BR>It has 3 tables (Main_Group, Group, Articles).<BR>Relation is Main_Group (1&#060;&#062;Many) Group<BR>Group (1&#060;&#062;Many)Articles<BR>1.<BR>Firstly I would like to list table Main_Group. That&#039s easy and I know to do this. But then I would like to browse in DB. So when I click with mouse button on one Main_Group, this open a new page with list of all Groups which is related to Main_Group that was selected with mouse click.<BR>2.<BR>Then I have list of all Groups of selected Main_Group. That means that table consist all Groups which are in selected Main_Group (with mouse click).<BR>Secondly I would like with mouse click to select one Group which create (generate) a new table with all articles which are related with selected Group.<BR>3.<BR>After all this I have Table with all articles related from Gruop, which is Related with Main_Group.<BR>4.<BR>And last thing, I select one atricle which open a new page with all data about this article from table Articles.<BR>Thats all.<BR>Please if somebody could help me or have some similiar asp code with mdb I would appreciate your help. Please send me answer with files to my mail.<BR>Thanks again.<BR>P.S.<BR>My mdb file:<BR>MAIN GROUP<BR>MainGroup_ID (1 to many)<BR>Title_MainGroup<BR>GROUP<BR>Main_Group_ID (many to 1)<BR>Group_ID (1 to many)<BR>Title_Group<BR>ARTICLES<BR>Group_ID (many to 1)<BR>Article_ID<BR>Title_Article<BR>Characteristi cs<BR>Price

  2. #2
    Join Date
    Dec 1969

    Default RE: 3 tables (mdb) and ASP ? Some solution?

    On the links (or whatever) include a unique identifier to the second table, then when you click, use the request("uniqueid") property to figure out what items should be returned and so on.<BR><BR>We are not here to write the code, just to help.<BR><BR>

Posting Permissions

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