AnsweredAssumed Answered

PC Konfigurator

Question asked by firebase on Apr 24, 2014
Latest reply on Apr 26, 2014 by firebase

Like • Show 0 Likes0
Comment • 4

Title

PC Konfigurator

Post

I habe one table that contains for example PC parts.

Itemname Pt. Number Price Type

Case1 00001 12,34 Case

Cass2 00002 23,45 Case

Mainboard1 00003 111,23 Mainboard

Mainboard1 00004 123,23 Mainboard

HD1 00005 90,23 HD

HD2 00006 95,23 HD

And so on

Now i want to have dropdown fields to choose the Itemname for each Type group to have it displaying the other two fields, price and Partnumber to have a total price at the end of all parts.

I am sitting since hours and not getting really on thetrack on how to solve this.

Any ideas?

No one else has this question

Outcomes

philmodjunk Apr 24, 2014 4:04 PM

Now i want to have dropdown fields to choose the Itemname for each Type group to have it displaying the other two fields, price and Partnumber to have a total price at the end of all parts.

And what exactly are you trying to document when you do that? The sale of those items on an invoice or order form?

Or might you be listing items to be assembled into a whole?

Or ???

In any case, it would seem that you need one or several related tables in order to do what you describe, not just a single table.

Actions

firebase Apr 24, 2014 4:14 PM

Yes, i need to assemble prices in general.

Letts say

Dropdown 1 for Cases

Dropdown 2 for Mainboards

Dropdown 3 for HDs

Plus the coresponding prices and Productnumbers to use them as a basis for calculations and further alligments to other informations.

But in general its only about price calculations.

The problem is that these items now in one list only dived by the "type" attribute. What i thought was to select the groups by sql select to put them into the dropdown, but i just cant figure out how to allign toe corresponding other 3 fields next to them.

It should look this this then:

New PC

Case1 00001 12,34

Mainboard1 00003 111,23

HD1 00005 90,23

Price xxx,xx

I have some extra field but not wrth to mention them here.

Actions

philmodjunk Apr 25, 2014 10:37 AM

As I said in my original post, this looks like something that needs more than a single table to do.

The first table in the following example might be named "computers", "Invoices" or something else, but the relationships remain the same.

     Start with these relationships:

     Computers-----<Computer_Component>-----Components

     Computers::__pkComputerID = Computer_Component::_fkComputerID
     Components::__pkComponentID = Computer_Component::_fkComponentID

     You can place a portal to Computer_Component on the Computers layout to list and select Components records for each given Computers record. Fields from Components can be included in the Portal to show additional info about each selected Components record and the _fkComponentID field can be set up with a value list for selecting Components records by their ID field.

A price field can be defined in Computer_Component that looks up the component price from Components. A calculation field defined in Computers can compute a total cost for all the specified components with this expression:

Sum ( Computer_Component::Price )

Actions

firebase Apr 26, 2014 4:53 AM

Thanx! I will try this today! :)

Actions

4 Replies

philmodjunk Apr 24, 2014 4:04 PM
Mark Correct
Correct Answer

          Now i want to have dropdown fields to choose the Itemname for each Type group to have it displaying the other two fields, price and Partnumber to have a total price at the end of all parts.

     And what exactly are you trying to document when you do that? The sale of those items on an invoice or order form?

     Or might you be listing items to be assembled into a whole?

     Or ???

     In any case, it would seem that you need one or several related tables in order to do what you describe, not just a single table.
Like • Show 0 Likes0
Actions
firebase Apr 24, 2014 4:14 PM
Mark Correct
Correct Answer
     Yes, i need to assemble prices in general.

     Letts say

     Dropdown 1 for Cases

     Dropdown 2 for Mainboards

     Dropdown 3 for HDs

     Plus the coresponding prices and Productnumbers to use them as a basis for calculations and further alligments to other informations.

     But in general its only about price calculations.

     The problem is that these items now in one list only dived by the "type" attribute. What i thought was to select the groups by sql select to put them into the dropdown, but i just cant figure out how to allign toe corresponding other 3 fields next to them.

     It should look this this then:

     New PC

     Case1              00001           12,34

     Mainboard1 00003          111,23

     HD1                 00005           90,23

                                     Price xxx,xx



     I have some extra field but not wrth to mention them here.
Like • Show 0 Likes0
Actions
philmodjunk Apr 25, 2014 10:37 AM
Mark Correct
Correct Answer
     As I said in my original post, this looks like something that needs more than a single table to do.

     The first table in the following example might be named "computers", "Invoices" or something else, but the relationships remain the same.

     Start with these relationships:

     Computers-----<Computer_Component>-----Components

     Computers::__pkComputerID = Computer_Component::_fkComputerID
     Components::__pkComponentID = Computer_Component::_fkComponentID

     You can place a portal to Computer_Component on the Computers layout to list and select Components records for each given Computers record. Fields from Components can be included in the Portal to show additional info about each selected Components record and the _fkComponentID field can be set up with a value list for selecting Components records by their ID field.

     A price field can be defined in Computer_Component that looks up the component price from Components. A calculation field defined in Computers can compute a total cost for all the specified components with this expression:

     Sum ( Computer_Component::Price )
Like • Show 0 Likes0
Actions
firebase Apr 26, 2014 4:53 AM
Mark Correct
Correct Answer
Thanx! I will try this today! :)
Like • Show 0 Likes0
Actions

PC Konfigurator

Title

Post

Outcomes

Related Content

Recommended Content