#1
  1. No Profile Picture
    Contributing User
    ASP Explorer (0 - 99 posts)

    Join Date
    Feb 2012
    Posts
    43
    Rep Power
    3

    Edit relationships in web database (ms inventory template)


    I've been using Desktop Product inventory database template and have about 20,000 products with a linked Inventory table
    I'd like to be able to create a nested table within products Basically regular card and foil card, prices for each linked to the inventory table

    So my problem 1: The relationship button is greyed out (I believe b/c it is a web database)

    I'd like to change it from Products ->Inventory
    to
    Products
    regular->inventory
    foil ->inventory

    I'm pretty sure that would be the best way

    Problem 2: Currently I already have Inventory for the products, I'll be adding the foil inventory. Is editing the relationship going to cause problems? Assuming I'm able to, I'll have to delete the existing relationship and create a new one, are the products still going to match up? Is it as simple as creating the new relationships first and then deleting the old?

    Thanks for any help. I wish there was more info on web databases, it seems not many people use them.
  2. #2
  3. No Profile Picture
    Contributing User
    ASP Explorer (0 - 99 posts)

    Join Date
    Feb 2012
    Posts
    43
    Rep Power
    3
    Alright well for anybody with the same problem, I've figured out that the way to edit the relationships is by using lookup fields

    I still dont really understand how to set up the one to many vs one to one though. I thought inserting a subdatasheet and a lookup field? One of my relationships shows up as a one to many correctly, but the other shows up as one to one, I dont see what I did differently with the two

    I wanted to add a new table but I can't get it to work so I'm just going to merge the two tables into one and be done with it.

    I had it working, but was having problems with creating a new entry
    Card->Products->Inventory
    adding a new card should call Product.CreateNew which then calls Inventory.CreateNew
    However to create a new product requires setting the supplierID, which I added as a parameter:

    Parameters
    prmCardID
    prmSupplierID

    Create a Record In Products
    Alias
    SetField
    Name CardID
    prmCardID
    SetField
    Name SupplierID
    prmSupplierID

    I get The identifier '[SupplierID]' Could not be found I have no idea why
    Last edited by samela101; February 18th, 2013 at 11:44 AM.

Similar Threads

  1. FindControl on Formview edit item template
    By GEM1204 in forum .NET Development
    Replies: 2
    Last Post: July 31st, 2008, 09:19 AM
  2. DataList opening in EDIT Template
    By Energizeer in forum .NET Development
    Replies: 2
    Last Post: January 29th, 2007, 04:55 AM
  3. DROPDOWN BOX in EDIT TEMPLATE
    By chewystuey in forum .NET Development
    Replies: 2
    Last Post: May 19th, 2006, 11:20 AM
  4. My Edit database page doesnt edit!
    By Drew123 in forum .NET Development
    Replies: 4
    Last Post: May 1st, 2004, 01:29 PM
  5. Database relationships and .asp webpages
    By Furner in forum Microsoft Access Help
    Replies: 0
    Last Post: March 1st, 2004, 12:03 PM

IMN logo majestic logo threadwatch logo seochat tools logo