D
Dennis
Hi,
I’m on Access via XP Office Pro w SP3 and XP Pro w SP3.
I’m still learning Access and sub-files so please understand if I do not use
the correct terminology.
I’m working on a display / inquiry form for a policy and its claims for a
given customer.
A customer can have one or more policies. A policy can have zero or more
claims. A claim can have one or more claimants. There is a policy table
with customer number in it. There is a claim table with the policy number in
it. And there is a claimant table with claim and claimant number in it.
Since I am new to sub-forms – I’ve read a lot, and played around a little,
but I’ve yet to tackle a project until now.
I would like to have a form where I enter a customer and it displays all of
the policies for the customer. Under each policy, it would display all of
that policy’s claims. And under each claim, it would display all of the
claimants.
Ideally the form would look something like:
Example 1:
Customer : ________
Policy # and policy info
Claim number and claim summary info
Claimant number and claimant info
Claimant number and claimant info
Claim number and claim summary info
Claimant number and claimant info
Policy # and policy info
And so on.
I am thinking about using one sub-form for the policy information, another
for the claim, and another for the claimant. As I say, I don’t know much
about sub-forms and I’m concerned that the display will look like:
Example 2:
Policy # and info
Policy # and info
Claim number and info
Claim number and info
Claimant information
Claimant information
Claimant information
I know that I’ll have to put a lot of time into this and I don’t mind.
However, in an effort to save myself from going down the wrong path and
beating my head against a brick wall for nothing, I would like to ask the
following question:
Will the sub-forms work like I hope they will work and display the data like
in sample 1 or will they sub-forms work like in sample 2?
Thanks you for you assistance.
Dennis
I’m on Access via XP Office Pro w SP3 and XP Pro w SP3.
I’m still learning Access and sub-files so please understand if I do not use
the correct terminology.
I’m working on a display / inquiry form for a policy and its claims for a
given customer.
A customer can have one or more policies. A policy can have zero or more
claims. A claim can have one or more claimants. There is a policy table
with customer number in it. There is a claim table with the policy number in
it. And there is a claimant table with claim and claimant number in it.
Since I am new to sub-forms – I’ve read a lot, and played around a little,
but I’ve yet to tackle a project until now.
I would like to have a form where I enter a customer and it displays all of
the policies for the customer. Under each policy, it would display all of
that policy’s claims. And under each claim, it would display all of the
claimants.
Ideally the form would look something like:
Example 1:
Customer : ________
Policy # and policy info
Claim number and claim summary info
Claimant number and claimant info
Claimant number and claimant info
Claim number and claim summary info
Claimant number and claimant info
Policy # and policy info
And so on.
I am thinking about using one sub-form for the policy information, another
for the claim, and another for the claimant. As I say, I don’t know much
about sub-forms and I’m concerned that the display will look like:
Example 2:
Policy # and info
Policy # and info
Claim number and info
Claim number and info
Claimant information
Claimant information
Claimant information
I know that I’ll have to put a lot of time into this and I don’t mind.
However, in an effort to save myself from going down the wrong path and
beating my head against a brick wall for nothing, I would like to ask the
following question:
Will the sub-forms work like I hope they will work and display the data like
in sample 1 or will they sub-forms work like in sample 2?
Thanks you for you assistance.
Dennis