February 15th, 2013, 10:06 AM
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
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.
February 18th, 2013, 11:37 AM
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
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:
Create a Record In Products
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.