This is a branch of This thread.
My case seems to be slightly different from the mentioned one. Hence, I thought a new thread may prevent over lapping comments and problems.
I have a product table. Currently 48895 records. And of course increasingly in a daily basis.
Some products are similar to each other. This similarity has no specific rule that can be fit to use tags etc.
I need simply set ProductA is similar to ProductB. (Manually or picking from a subform, listbox, ...)
Some requirement:
I really appreciate any advice on the table design.
Thanks
@MajP I think it's all I need.
Take your time and advise whenever you have some free time.
Thanks again.
Note: In my real world (my profession, CAD), similar designs are set as Configuration. And these similar parts are managed by PDM with a SQL server as BE.
I was just thinking to do it in Access (because I need some custom capabilities that can not be managed in an out of box software)
My case seems to be slightly different from the mentioned one. Hence, I thought a new thread may prevent over lapping comments and problems.
I have a product table. Currently 48895 records. And of course increasingly in a daily basis.
Some products are similar to each other. This similarity has no specific rule that can be fit to use tags etc.
I need simply set ProductA is similar to ProductB. (Manually or picking from a subform, listbox, ...)
Some requirement:
- If ProductA is similar to ProductB, then when I filter Products form for each product, I need to see the other product too. (a listbox or subform, or any other way)
- If ProductA is similar to ProductB and ProductB is similar to ProductC, then searching for each product, should bring up the other two product.
(The famous rule : If A=B and B=C then A=C) --> for my case, simply change = sign to Similar - Any product may have one or many similar products.
- There's no limit in the count of similar products.
I really appreciate any advice on the table design.
Thanks
@MajP I think it's all I need.
Take your time and advise whenever you have some free time.
Thanks again.
Note: In my real world (my profession, CAD), similar designs are set as Configuration. And these similar parts are managed by PDM with a SQL server as BE.
I was just thinking to do it in Access (because I need some custom capabilities that can not be managed in an out of box software)
Last edited: