auto fill records with combo box

[tidwellbj]

I am trying to create a simple subform but for some reason it is not working.


Table 1 - tblequipmentprice (This table is fixed priced) one to many to
table 2
ID - (PK)
DESCRIPTION
UNIT
PRICE

Table 2 - tblinstallqty
IDqty (PK)
quantity
ID

I am trying to create a subform where I can select DESCRIPTION from a combo
box and it auto fills the records for UNIT and PRICE. Then the only
information that needs to be inputed is the QUANTITY field.

The problem I am having is when I select from the combo box it pulls the
records back into table 1 (which shouldn't). I have tried to do a query but
still have the same problem.

 

[Jeff Boyce]

You mentioned putting "DESCRIPTION" in a subform. What's in the main form?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[tidwellbj via AccessMonster.com]

Basic customer information.

You mentioned putting "DESCRIPTION" in a subform. What's in the main form?

I am trying to create a simple subform but for some reason it is not working.

[quoted text clipped - 17 lines]

records back into table 1 (which shouldn't). I have tried to do a query but
still have the same problem.

 

[tidwellbj via AccessMonster.com]

Basic customer information.

You mentioned putting "DESCRIPTION" in a subform. What's in the main form?

I am trying to create a simple subform but for some reason it is not working.

[quoted text clipped - 17 lines]

records back into table 1 (which shouldn't). I have tried to do a query but
still have the same problem.

 

[Jeff Boyce]

I guess I'm not understanding why a particular thing (with a DESCRIPTION)
would have many "Quantities".

I guess I don't understand enough about what business need you are trying to
solve...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Basic customer information.

You mentioned putting "DESCRIPTION" in a subform. What's in the main form?

I am trying to create a simple subform but for some reason it is not working.

[quoted text clipped - 17 lines]

records back into table 1 (which shouldn't). I have tried to do a query but
still have the same problem.

 

[tidwellbj via AccessMonster.com]

DESCRIPTION is the source for my combo box. I just want to create a simple
form where you select a "description" and it auto fills the set price for
that value.

Example of what I want on my form.

DESCRIPTION (combo box, choose a value and it pulls the correct price)
PRICE (auto filled)
QUANTITY (enter quantity)
TOTAL PRICE (=[price]*[quantity])

I have tried creating the form from a query but it wouldn't work. When I
choose a "description" it would add a new record back into the table it was
pulling the information from.

I guess I'm not understanding why a particular thing (with a DESCRIPTION)
would have many "Quantities".

I guess I don't understand enough about what business need you are trying to
solve...

Basic customer information.

[quoted text clipped - 5 lines]

 

[Jeff Boyce]

You're describing the form. I'm talking about the underlying data. In
Access, it all starts with the data.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

DESCRIPTION is the source for my combo box. I just want to create a simple
form where you select a "description" and it auto fills the set price for
that value.

Example of what I want on my form.

DESCRIPTION (combo box, choose a value and it pulls the correct price)
PRICE (auto filled)
QUANTITY (enter quantity)
TOTAL PRICE (=[price]*[quantity])

I have tried creating the form from a query but it wouldn't work. When I
choose a "description" it would add a new record back into the table it was
pulling the information from.

I guess I'm not understanding why a particular thing (with a DESCRIPTION)
would have many "Quantities".

I guess I don't understand enough about what business need you are trying to
solve...

Basic customer information.

[quoted text clipped - 5 lines]

records back into table 1 (which shouldn't). I have tried to do a query but
still have the same problem.

 

[tidwellbj via AccessMonster.com]

Table 1
ID- Auto Number - PK
Description - text
Unit - text
Price- Currency

Table 2
IDqty - Auto Number PK
ID- Number
quantity - number

You're describing the form. I'm talking about the underlying data. In
Access, it all starts with the data.

DESCRIPTION is the source for my combo box. I just want to create a simple
form where you select a "description" and it auto fills the set price for

[quoted text clipped - 22 lines]

 

[Jeff Boyce]

If you only describe your current structure, and don't provide information
about WHY you are using that structure (i.e., what business area this
covers), it will be tough to offer relevant suggestions.

My previous question stands ... What kind of thing has a one-to-many
relationship between "unit" and "quantity"?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Table 1
ID- Auto Number - PK
Description - text
Unit - text
Price- Currency

Table 2
IDqty - Auto Number PK
ID- Number
quantity - number

You're describing the form. I'm talking about the underlying data. In
Access, it all starts with the data.

DESCRIPTION is the source for my combo box. I just want to create a simple
form where you select a "description" and it auto fills the set price

for
[quoted text clipped - 22 lines]

records back into table 1 (which shouldn't). I have tried to do a query but
still have the same problem.