relationships select list
Posted: Sat Jul 04, 2009 11:35 am
Hello,
there is a 2way relationship between table "Shops" and "Products".
Obviously, a Product can be listed in several Shops and a Shop can contain many different Products, so I have these relationship.ini files:
Products:
[Shops]
Shops.ID = ShopProducts.ShopID
ShopProducts.ProductID = "$ID"
Shops:
[Products]
Products.ID = ShopProducts.ProductID
ShopProducts.ShopID = "$ID"
Basically, this works for me, but I have several questions and difficulties that I could not find in the manuals - sorry, but I'm just a newbie to xataface and I'm not native English, perhaps you can help.
What I want to achieve: I select a specific product. Under the "Shops" menu, I can select all the shop names where this product will be listed (not the ID but the actual short name of the shop is shown). Either from a select list (with CTRL-key I can select multiple shops) or with a comma-separated text field, I won't mind.
What goes wrong:
1. I select a product and click on "Shops" and "add new record".
I get a select list of all the available shops (just the Shop ID is shown) and a text field "ShopID: ___" below that. The selection from the list is not entered into the field, but I have to manually type the shop ID into the text field to make this work...
I would like to select multiple stores for this product from the select list and just post this to the database.
2. After adding one of the Shops to this Product relationship, a list with all the join fields is shown:
ID Name DescriptionShort ShopID ProductID
I don't want to confuse the user and just show the shop's name (DescriptionShort) in the list of shops for this product, nothing more. How can I disable certain fields to become visible in this list?
Thanks for any hints - I'll certainly need to dig a bit more into the docs
Bernd
there is a 2way relationship between table "Shops" and "Products".
Obviously, a Product can be listed in several Shops and a Shop can contain many different Products, so I have these relationship.ini files:
Products:
[Shops]
Shops.ID = ShopProducts.ShopID
ShopProducts.ProductID = "$ID"
Shops:
[Products]
Products.ID = ShopProducts.ProductID
ShopProducts.ShopID = "$ID"
Basically, this works for me, but I have several questions and difficulties that I could not find in the manuals - sorry, but I'm just a newbie to xataface and I'm not native English, perhaps you can help.
What I want to achieve: I select a specific product. Under the "Shops" menu, I can select all the shop names where this product will be listed (not the ID but the actual short name of the shop is shown). Either from a select list (with CTRL-key I can select multiple shops) or with a comma-separated text field, I won't mind.
What goes wrong:
1. I select a product and click on "Shops" and "add new record".
I get a select list of all the available shops (just the Shop ID is shown) and a text field "ShopID: ___" below that. The selection from the list is not entered into the field, but I have to manually type the shop ID into the text field to make this work...
I would like to select multiple stores for this product from the select list and just post this to the database.
2. After adding one of the Shops to this Product relationship, a list with all the join fields is shown:
ID Name DescriptionShort ShopID ProductID
I don't want to confuse the user and just show the shop's name (DescriptionShort) in the list of shops for this product, nothing more. How can I disable certain fields to become visible in this list?
Thanks for any hints - I'll certainly need to dig a bit more into the docs
Bernd