Implement recursive relation/table in access

[denjames]

I have a recursive relationship (in an ER-diagram) that I need to put in an access-database.

In my case I have a list of parts that a customer can buy in combinations and quantities that he wants. From these parts, their are also made 3 different standard configurations who can be bought at a good price (lower than total of prices of spare parts). Moreover the customer can choose to make his own configuration from the list with parts.

How can I implement this in Access?

Thanks in advance!

 

[spikepl]

What is the recursive bit? It's not evident from your verbal description. Example or pic would help.

 

[denjames]

I have a table in access with parts in like frame, memory, hdd, keyboard etc.

A customer can buy these parts just as spare parts. But he can also buy one or more (we got 3) of our standard configurations. These standard configurations are assembled with parts form the partlist, but can be bought at a fixed price (lower than totale of prices of the spare parts).

The customer can also make his own configuration with parts form the partlist.

How can I do this in access?



Example:
Customer orders : 2 frames

1 standardconfiguratie type 1
1 self specified configuration assembled with 1 frame, 2HDD's, 1GB memory...
​

Thnx

 

[jdraw]

Can you show us the E-R diagram? or Relationships? as jpg

What have you tried? What results?

 

[gemma-the-husky]

I think you would need a separate "assembly" table - to show that eg, assembly pack 1, consists of 2 items of part 12, and 1 item of part 17.

you are getting into very very complex coding. Inventory is not easy.

 

[denjames]

A picture of the full ER is added as attachment

Maybe some extra information concerning the full ER:
- Selling prices don't need to be automatically adapted with buying prices. The company set them fixed and adapt them manually.
Combinations of loose parts, standard configurations and customer configurations are possible in 1 order.

Thanx