when selecting from a drop down list automatically enter the price for it

[Scotchegg]

I have a table called FixingsListT which has a list of fixings with the price each next to it.


I then have a table called FixingsT which i select a fixing from a drop down list ( which is from FixingsListT ) i need the price each to be entered automatically from the FixingsListT how do i do this?

[Welshgasman]

Bring in the amount as an extra column and refer to that column.

[mike60smart]

You should not be trying to do this in the Table.

You would create a Data Input Form which would be based on the Table.

Then in the Design of the Form you would use the Wizard to create a Combobox to Lookup the values from FixingsListT

You would select both the FixingName and Price each

Then you would refer to the ComboboxName to obtain the 2nd Column Value

=[ComboboxName].Column(2)

[Welshgasman]

You should not be trying to do this in the Table.

You would create a Data Input Form which would be based on the Table.

Then in the Design of the Form you would use the Wizard to create a Combobox to Lookup the values from FixingsListT

You would select both the FixingName and Price each

Then you would refer to the ComboboxName to obtain the 2nd Column Value

=[ComboboxName].Column(2)

2nd column would be (1) Mike?

[mike60smart]

Hi Welshgasman

Strange I always thought that the Combobox would display in the following Order:-

PK Column 0
Fixingname Column 1
Price Each Column 2
Column Count 3
Column Widths 0cm;2.54cm;2.54cm;

[Welshgasman]

Hi Welshgasman

Strange I always thought that the Combobox would display in the following Order:-

PK Column 0
Fixingname Column 1
Price Each Column 2
Column Count 3
Column Widths 0cm;2.54cm;2.54cm;

Yes, that is correct and your second column has an index of 1. Your third column has the index of 2 ? Even your Column Count tells you 3, and the Price is the last column.

You are confusing column count with index as the index starts at 0?
So the way you have your columns arranged your syntax was correct, but you referred to the second column?, not the column indexed by the value 2, which is the third column. ?

[mike60smart]

My apologies

It should have read as follows:-

Then you would refer to the ComboboxName to obtain the 3rd Column Value

[Scotchegg]

Brilliant thanks worked great.