[ic] Several products tables

[Luis Filipe Silvestre Marques]

  Hi. I have 2 questions:

1 -  I'm starting to work with InterChange, and I want to put several tables 
with products (or something similar). The table's sku are not used by the 
products, so I want to know if I can use an Integer index (a la mysql) in 
each table. This would make diferent products to have the same sku (but 
belonging to different tables). Is this possible, or must I use unique skus 
for every product??

2 - Other thing is to build relations between the products in different 
tables. I will try to use an extra table with the relations (allowing 
multiple cases). Is this the best way of doing it in InterChange.


-- 
Luís Filipe Silvestre Marques
L8 Tecnologias de Informação, Lda
Rua Alves Redol Nº11 - 1 Andar 1000-030 LISBOA
Tel: +351 217800009 Fax: +351 217800012
www.l8ti.com