Complicated Query Problem

  • Thread starter Thread starter Sam A
  • Start date Start date
S

Sam A

Ok. I have four tables which link:
Programme
Policy
Order
Line
in that hierachical order.
One programme can have many policies, each policy can have
many orders, so on and so forth.

THe porblem is on my data entry form, I need the 'Line' to
look at a reference table to autofil some info, and to
make some calculations based on info in the Order and
Policy tables.

I have therefore created a query which links these through
and pulls the fields through.
However, when I try to enter a new line, although the new
entry looks possible as the * shows on the record locater,
no entries are possible. The fields dont allow you to
enter data.

I know this is complicated and not sure if you can help.
Thank you
Sam
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Why not use subforms. If using ACC2002, and above, there can be (I
believe) 7 subforms nested:

Line would be a subform in Order.
Link Line.OrderID -> Order.OrderID.
Order would be a subform in Policy.
Link Order.PolicyID -> Policy.PolicyID
Policy would be a subform in Programme.
Link Policy.ProgramID -> Programme.ProgramID

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQYgs0oechKqOuFEgEQIqwgCg42s76/wcs9sZiVfkM1YLNoqQTN4AoOOJ
h1FVll9Qo73q3qezh2g/N4Vp
=bJwA
-----END PGP SIGNATURE-----
 
HI.
I have got subforms in. The problem is - on the lowest
level form, I have had to make this via a query as it
calculates a couple of fields taking info from the higher
levels, and looks and a further table for some fields to
complete (Order customer details), I now cant get it to
accept any new data. All the data in from a one of
download from a SQL table.
 
Back
Top