subform question

[mvrp350]

Hello,

I have a DB with 3 tables:
Customers, remarks and action

Customers:
Customer_id
name
address
etc

remarks:
remark_id
customer_id
remark
start
finished

action:
action_id
remark_id
action
date
finished

Each customer can have multiple remarks
Each remark can result in multiple actions

I have a form that displays our customer-data. On this form is a tab for remarks.
When I click on that tab I want to see all the remarks from that customer, and along with each remark a list of actions.

Remark 1
Action 1
Action 2
Action 3
Remark 2
Action 4
Action 5

I have tried to achieve this by using subforms, but it doesn't allow continous forms. So when I use that I see only:
Remark 1
Action 1
Action 2
Action 3

So I'm missing all the information for Remark 2.

Can someone help me on this one?

Thanx mvrp350

 

[llkhoutx]

Access works that way. A form containing one or more subforms cannot be continuous.

However, you accomplish the same thing by making your (main) form a subform and having the other subforms also on that new main form. You have to requery the linked subforms on the OnCurrrent event of the "main" subform.

Otherwise, use the navigation buttons to move to other records.

 

[mvrp350]

I don't fully understand what you mean. Can you post a small example of this so I can see what you mean. If it is working the way I'd like to see I'll use that idea,.

Thanx, mvrp350