Edit relationships in web database (ms inventory template)

[samela101]

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.

[samela101]

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