Complex Select Query Won't Allow Data To Be Entered

[Guest]

Hello All,
I'm designing an Inventory Control and Invoicing Database for a rental
business and am having problems with the query that drives the entry of the
line item data. Basically the user selects an item category from a combo
box. Their selection then populates another combo box with items of that
category. They then select an item which causes other controls on the form
to be populated with info about that item. The user must then enter the
number of items being rented and the period of time that the item is being
rented for. The rental period is selected from another combo box. Selecting
the rental period should then cause the rental fee control to be populated
with the rental fee value for that item and rental period. Possible rental
periods are Daily Weekly and Monthly. When I add the Part Rental Fees Table
to the query so I can retrieve the rental fee for the item, the query no
longer allows me to enter any data. I'm sure it has something to do with the
relationships between the tables, but I cannot see the problem. Any help you
can offer is appreciated.

 

[MGFoster]

Hello All,
I'm designing an Inventory Control and Invoicing Database for a rental
business and am having problems with the query that drives the entry of the
line item data. Basically the user selects an item category from a combo
box. Their selection then populates another combo box with items of that
category. They then select an item which causes other controls on the form
to be populated with info about that item. The user must then enter the
number of items being rented and the period of time that the item is being
rented for. The rental period is selected from another combo box. Selecting
the rental period should then cause the rental fee control to be populated
with the rental fee value for that item and rental period. Possible rental
periods are Daily Weekly and Monthly. When I add the Part Rental Fees Table
to the query so I can retrieve the rental fee for the item, the query no
longer allows me to enter any data. I'm sure it has something to do with the
relationships between the tables, but I cannot see the problem. Any help you
can offer is appreciated.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

A common solution to non-updateable queries is to include DISTINCTROW in
the SELECT clause:

SELECT DISTINCTROW col1, col2, etc.

Personally, I believe you're not using Access forms the way they should
be used. Read up on Forms & Subforms in the Help file.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQjYD54echKqOuFEgEQL9HQCgs7yO/jsnL8vM3xNP/iuBn4YLZJEAni/E
X1p0Vcv8IINmcVvhCmoXBGYh
=KsZ/
-----END PGP SIGNATURE-----