Discussion Forum: Thread 255929

 Author: gloudo View Messages Posted By gloudo
 Posted: Aug 10, 2019 07:22
 Subject: Alternate Item Relations
 Viewed: 48 times
 Topic: Catalog
 Status:Open
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

gloudo (70)

Location:  Netherlands, Zuid-Holland
Member Since Contact Type Status
Jan 17, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Gloudo
Hi All,

I'm building a database in MS Access where I want to compare my sets with
a different set to see if I can build the different set with the parts I have.

What I like to know is, is there a downloadable table with related items, so
if I don't have the original inventory item the DB will search the alternative
items to see if there is a match and give me the quantity of the alternate item?

Or is there an other way to relate the alternate item to the original inventory
item?

Thanx
 Author: Soviet View Messages Posted By Soviet
 Posted: Aug 10, 2019 07:30
 Subject: Re: Alternate Item Relations
 Viewed: 23 times
 Topic: Catalog
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

Soviet (338)

Location:  Poland, w. Pomorskie
Member Since Contact Type Status
Mar 20, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Flat Tile
In Catalog, gloudo writes:
  Hi All,

I'm building a database in MS Access where I want to compare my sets with
a different set to see if I can build the different set with the parts I have.

What I like to know is, is there a downloadable table with related items, so
if I don't have the original inventory item the DB will search the alternative
items to see if there is a match and give me the quantity of the alternate item?

Or is there an other way to relate the alternate item to the original inventory
item?

Thanx

Have you heard about Rebrickable.com?
 Author: hpoort View Messages Posted By hpoort
 Posted: Aug 10, 2019 07:41
 Subject: Re: Alternate Item Relations
 Viewed: 21 times
 Topic: Catalog
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

hpoort (410)

Location:  Netherlands, Groningen
Member Since Contact Type Status
Oct 11, 2014 Contact Member Buyer
Buying Privileges - OK
In Catalog, gloudo writes:
  Hi All,

I'm building a database in MS Access where I want to compare my sets with
a different set to see if I can build the different set with the parts I have.

What I like to know is, is there a downloadable table with related items, so
if I don't have the original inventory item the DB will search the alternative
items to see if there is a match and give me the quantity of the alternate item?

Or is there an other way to relate the alternate item to the original inventory
item?

Thanx

Generally similar parts can be found on
https://www.bricklink.com/catalogRelList.asp?v=0&pg=1&relID=4
Not easily downloadable, but copy-paste should work.

Then there is:
https://www.bricklink.com/help.asp?helpID=2488
and similar information can be found through:
https://www.bricklink.com/help.asp?topicID=21

If you only want to know about alternates that are registered within a set, you
will have to look at the inventory of that set through:
https://www.bricklink.com/catalogInv.asp
or download through:
https://www.bricklink.com/catalogDownload.asp


Good luck with it.


Hans-Peter
 Author: gloudo View Messages Posted By gloudo
 Posted: Aug 10, 2019 07:56
 Subject: Re: Alternate Item Relations
 Viewed: 27 times
 Topic: Catalog
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

gloudo (70)

Location:  Netherlands, Zuid-Holland
Member Since Contact Type Status
Jan 17, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Gloudo
In Catalog, gloudo writes:
  Hi All,

I'm building a database in MS Access where I want to compare my sets with
a different set to see if I can build the different set with the parts I have.

What I like to know is, is there a downloadable table with related items, so
if I don't have the original inventory item the DB will search the alternative
items to see if there is a match and give me the quantity of the alternate item?

Or is there an other way to relate the alternate item to the original inventory
item?

Thanx

Thanx all for the quick replies.
I found a downloadable table on rebrickable. For me that is the most useful solution
for my problem.