Can I do this in a sub-form?

[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

 

[golfinray]

Martin Greene has a great little database example of how to do just exactly
what you want and the code and instructions to do it with at
www.fontstuff.com or try Allen Browne at www.allenbrowne.com

 

[Dennis]

Milton,

Thanks for you response. I was aware of Allen Browne's web site and had
already checked that and there was nothing there. I did not know about
Martin Greene web site. I looked through his sight and did not see what I
wanted. He does have a lot of other stuff that will help me thought.

Did I miss something on his site? I looked under Access, VBA, Downloads,
and his index.

Do you happen to know the name of his sample db?

Any other suggestions?