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?
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.
Yes, i need to assemble prices in general.
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:
Case1 00001 12,34
Mainboard1 00003 111,23
HD1 00005 90,23
I have some extra field but not wrth to mention them here.
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::__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 )
Thanx! I will try this today! :)